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?

[George_Tarasi2]

Thanks!!!!!   After receiving your first message I wrote

select it.itemtypename from HSI.DOCTYPEKEYSET ds, hsi.doctype it

where

keysettablenum = 299

and

it.itemtypenum = ds.itemtypenum

[Brad_Phillips]

Glad to help.  Thanks for using Community.  🙂

[Joe_Pineda]

Thanks Brad. That helped me too.

G: so your very first question is not what you wanted? - the actual documents where the MIKG is used???? 

[George_Tarasi2]

Thanks for your help as well Jose.  I suppose my first post was confusing, sorry about that. 

[Joe_Pineda]

No worries G!