AutoFill Keyword Sets (AFKS additional Keyword)

[Martin_Bosshard]

Hi everyone

We have 4 AutoFill Keyword Sets and each of the will need an additional Keyword.

• eg. existing AFKS: SSN, Firstname, Lastname
• eg. new AFKS: SSN, Firstname, Lastname, Departement

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?

[James_Perry · Accepted solution]

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.

[Martin_Bosshard]

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 🙂

[James_Perry]

Happy to help and save you time and trouble.