Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

How to find table/column name for a form?

To find the database table name in which the records of the form are saved, run the below SQL:

select convert(xml using utf8) from dyextn_containers where caption = '<Form Name>'

The output would be the form XML file and the form ID and database table name in which the form records are stored. E.g.: Form ID is 86, and DB table name is 'DE_E_11006'

<container id="1">   <id>86</id>   <name>chemotherapyForm</name>   <caption>Chemotherapy form</caption>   <dbTableName>DE_E_11006</dbTableName>.......

 

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com