Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 = '
<form
<Form 
name>
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'

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