08-13-2020 11:06 AM
In configuration, its necessary to assign an eform to a document type each time the eform is updated.
I want to query for only the eforms currently in use by a document type.
Please let me know if that is available in a table.
11-22-2023 12:22 PM
George,
Using the Configuration Report, it appears that the table HSI.DTELECTRONICFORM provides the cross reference and will provide which document is currently mapped to an electronic form doc type. See below:
select
t1.*
,rtrim(t2.itemtypename) as DocumentType
,rtrim(t3.itemname) as Document
from hsi.dtelectronicform t1, hsi.doctype t2, hsi.itemdata t3
where t1.itemtypenum = t2.itemtypenum
and t1.formitemnum = t3.itemnum
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.