01-28-2014 08:11 AM
I try to understand how the keyword type group is implemented in the database so that I can automate query creation.
The questions I am seeking answer to are the following:
1. How do I know which 'keyword type group' is used for a 'document type'? Which table is used to track that info and how that table is structured?
2. How do I know which 'keyword type' is part of a 'keyword type group'? Again, which table is used to track that and how that table is structured?
3. What column in the table, which shall be answered in question 2 above, is used to link to the keysettablenum field in hsi.keywordset table?
* By looking up all these info in the configuration, I can write the query manually. However, that is too much to write and prone to errors.
Thanks.
Duncan
01-28-2014 08:47 AM
Duncan,
Keyword Groups are maintained in a keygroupdataXYZ or keyrecorddataXYZ table depending on whether or not they are Multi-Instance. The structure of these tables contain the itemnumber, and then the individual keywords as columns within them.
Look for me to follow-up with additional information in a separate email.
As far as future reference, Hyland Software does have a DataBase Reporting Guide that provides a majority of the commonly used tables and the relationships that is a great resource for building reports and custom queries.
-Aaron
01-30-2014 05:14 AM
Hi Duncan -
You can find what keyword type groups are associated with a doctype by looking in the doctypekeyset table. That table contains the document type numner (itemtypenum), the keyword group type (iskeytypegroup), and the keyword type group number (keysettablenum) which can be joined back to keywordset.
The iskeytypegroup column will tell you whether the keyword type group is a Single instance (1), Multi-instance (2) or an AutoFill (0).
For the keywords associated with a particular keyword type group, look in keysetxkeytype, which contains the keyword type number (keytypenum), the keyword type group number (keysettablenum), and the sequence number (seqnum). Again, keysettablenum can be joined back to keywordset.
Hope this helps.
09-25-2015 09:46 AM
09-25-2015 10:09 AM
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.