08-19-2016 10:47 AM
Hi,
I do have name of the Html E-Form and I'm trying to write a SQL query to get the document types where that html form is configured as E-Form using onbase configuration (E Form options for document type window).
Any help would be much appreciated.
Thanks.
08-19-2016 03:41 PM
Something like this should work. Replace the '12345678' in the WHERE clause to reflect the document handle of the E-form you want to lookup.
SELECT ef.itemtypenum, dt.itemtypename
FROM hsi.dtelectronicform ef
INNER JOIN hsi.doctype dt ON dt.itemtypenum = ef.itemtypenum
WHERE ef.formitemnum = '12345678'
08-19-2016 03:41 PM
Something like this should work. Replace the '12345678' in the WHERE clause to reflect the document handle of the E-form you want to lookup.
SELECT ef.itemtypenum, dt.itemtypename
FROM hsi.dtelectronicform ef
INNER JOIN hsi.doctype dt ON dt.itemtypenum = ef.itemtypenum
WHERE ef.formitemnum = '12345678'
08-22-2016 09:07 AM
08-22-2016 09:08 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.