09-17-2020 07:41 AM
I am a hosted customer, and so don't have access to my database configuration. Could someone tell me if there is a table that ties together doc types and the autofills applied to it at the doc type level?
I appreciate the help!
Thanks,
Alexa
09-17-2020 07:46 AM
Hi Alexa,
Here's what we use:
SELECT Trim(G.itemtypegroupname) AS Document_Type_Group, Trim(D.itemtypename) AS Doctype, Cast(D.itemtypenum AS INT) AS Doctype_Number, Trim(AK.keysetname) AS AutoFill_KeySet_Name FROM hsi.doctype D left join filetype F ON D.filetypenum = F.filetypenum left join (SELECT S.itemtypenum, K.keysetname, K.keysettablenum, K.iskeytypegroup FROM hsi.doctypekeyset S, hsi.keywordset K WHERE S.keysettablenum = K.keysettablenum AND K.iskeytypegroup = '0') AK ON D.itemtypenum = AK.itemtypenum, hsi.itemtypegroup G WHERE D.itemtypegroupnum = G.itemtypegroupnum ORDER BY 1, 2, 3;
09-17-2020 07:46 AM
Hi Alexa,
Here's what we use:
SELECT Trim(G.itemtypegroupname) AS Document_Type_Group, Trim(D.itemtypename) AS Doctype, Cast(D.itemtypenum AS INT) AS Doctype_Number, Trim(AK.keysetname) AS AutoFill_KeySet_Name FROM hsi.doctype D left join filetype F ON D.filetypenum = F.filetypenum left join (SELECT S.itemtypenum, K.keysetname, K.keysettablenum, K.iskeytypegroup FROM hsi.doctypekeyset S, hsi.keywordset K WHERE S.keysettablenum = K.keysettablenum AND K.iskeytypegroup = '0') AK ON D.itemtypenum = AK.itemtypenum, hsi.itemtypegroup G WHERE D.itemtypegroupnum = G.itemtypegroupnum ORDER BY 1, 2, 3;
09-17-2020 08:16 AM
Larissa, this is fantastic, thank you!
03-02-2022 08:16 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.