MIKG

[George_Tarasi2]

Is it possible to query for what documents a particular Multi Instance Keyword group is used on?

Or query a docuemtn type and have the results show that an MIKG is used on that document type?

[Joe_Pineda]

Yes.

The MIKG wil be something like keyrecorddata103 (whatever your mikg number is), and it contains the itemnum column. The itemnum is your link to hsi.doctype.

[George_Tarasi2]

My table is .hsi.keyrecorddata299.  It contains values for the keywords. 

My current query lists the keyword type that are attached to each document type.  Not keyword values.

I want to specify if the document type uses an MIKG for these keywords.

[Brad_Phillips]

The table you're looking for is HSI.DOCTYPEKEYSET.  That's the link between document types and MIKGS.  Since your MIKG # is 229, look for all records in HSI.DOCTYPEKEYSET with a KEYSETTABLENUM of 229.  That's your list of document types that use the MIKG.

[Brad_Phillips]

And since I take things too far, here's a script you can use:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDselect keysetname, itemtypename  from hsi.keywordset KWSinner join hsi.doctypekeyset DTKS on KWS.keysettablenum = DTKS.keysettablenuminner join hsi.doctype DTon DTKS.itemtypenum = DT.itemtypenumwhere DTKS.keysettablenum = 229