current eforms

[George_Tarasi]

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.

[David_Hoffman]

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