To find the database table name in which the records of the form are saved, run the below SQL:
Code Block |
---|
select convert(xml using utf8) from dyextn_containers where caption = ' |
|
<formname>;The output would be the form XML file along with and the form ID and database table name in which the form records are stored. E. Egg.: Form ID is 86, and DB table name is 'DE_E_11006'
Code Block |
---|
<container id="1">
<id>86</id>
<name>chemotherapyForm</name>
<caption>Chemotherapy form</caption>
<dbTableName>DE_E_11006</dbTableName>....... |
|