02-19-2021 02:34 AM
Hi everyone
We have 4 AutoFill Keyword Sets and each of the will need an additional Keyword.
I found a great SQL query to determine the usage of those AFKS on Documents and WFL action:
https://community.hyland.com/forum/threads/73808-sql-to-find-what-uses-an-autofill-keyword-set
--AFKS on DocType
select S.KEYSETNAME as KeywordSetName, D.ITEMTYPENAME as DocTypeName
from KEYWORDSET S, DOCTYPE D, DOCTYPEKEYSET X
where X.KEYSETTABLENUM = S.KEYSETTABLENUM
and D.ITEMTYPENUM = X.ITEMTYPENUM
and S.ISKEYTYPEGROUP='0'
order by 1
;
--AFKS on WFL
select A.ACTIONNUM, A.ACTIONNAME, A.ACTIONTYPE, L.LIFECYCLENAME, S.KEYSETNAME
from ACTION A, LIFECYCLE L, KEYWORDSET S
where A.SCOPE = L.LCNUM and A.NOTETYPENUM = S.KEYSETTABLENUM
and A.ACTIONTYPE = '85'
order by L.LIFECYCLENAME
;
330 AFKS on DocType level and 20 on WFL Level with 3 different environments.
Changing this manually will require a lot of time and might lead to misconfiguration. Is there a smarter way to replace AFKS x with AFKS y on the whole solution?
02-19-2021 07:41 AM
If you are adding the additional keyword to the end of the AFKS and do not need two versions of the AFKS you can update the current AFKS which will update it in all referenced locations. If the keyword is not already on the Document Types you can add the keyword to multiple doctypes from the Keyword Types dialog by selecting the keyword and then clicking Document Types button. You can then select the Document Types the keyword will need to be added to then click the Add >> button.
02-19-2021 07:41 AM
If you are adding the additional keyword to the end of the AFKS and do not need two versions of the AFKS you can update the current AFKS which will update it in all referenced locations. If the keyword is not already on the Document Types you can add the keyword to multiple doctypes from the Keyword Types dialog by selecting the keyword and then clicking Document Types button. You can then select the Document Types the keyword will need to be added to then click the Add >> button.
02-19-2021 08:11 AM
Thanks for that. I didn't know that.
Usually we have creative customers, adding it in the middle.
You saved me a lot of trouble 🙂
02-19-2021 09:24 AM
Happy to help and save you time and trouble.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.