05-21-2019 07:08 AM
We have encountered out of memory issues and high CPU spikes on our web servers and it has been determined that it was related to a keyword having the Allow Drop - Down Lists turned on. I would like to query the hsi.keytypetable and quickly identify other keywords that have this option selected. There is a column of dropdownset, however all of the keywords contain a value of 0, so I do not believe that to be the correct indicator.
Thank you in Advance.
Sheryl
05-21-2019 07:45 AM
Hi Sheryl,
This setting is stored as a bitwise value in the keytypeflags column. For SQL Server, the query below should return the keyword names that have the allow drop down lists checkbox enabled:
SELECT keytype AS 'Keyword'
FROM hsi.keytypetable with (nolock)
WHERE keytypeflags & 67108864 = 67108864
ORDER BY 1
Thanks,
Nick
05-21-2019 07:45 AM
Hi Sheryl,
This setting is stored as a bitwise value in the keytypeflags column. For SQL Server, the query below should return the keyword names that have the allow drop down lists checkbox enabled:
SELECT keytype AS 'Keyword'
FROM hsi.keytypetable with (nolock)
WHERE keytypeflags & 67108864 = 67108864
ORDER BY 1
Thanks,
Nick
05-21-2019 10:04 AM
Thank you so very much.
04-23-2021 07:02 AM
This is not entirely true, because the keyword could ALSO have "Use Keyword Data Set" selected at the same time, which overrides "Allow Drop - Down List"
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.