Is there any query to get document types where particular html form is set as E form for those document types using OB configuration?

[Pravin_Shelar]

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.

[Connor_Marment1 · Accepted solution]

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'

[Pravin_Shelar]

Awesome, Thanks Connor!

[Pravin_Shelar]

Nice - Thank you.