How to recover data for deleted form?

Below mentioned tables will be required while the update

The steps mentioned below will help the user to recover the data for the form deleted or detached from the level.

When form is deleted

For example, The user has accidentally deleted the Chemotherapy form. Run the below SQLs:

select IDENTIFIER, NAME, DELETED_ON from dyextn_containers where caption = 'Chemotherapy form';

The output of this command would be:

To reactivate the form, the deleted_on date needs to be blanked out. Run the below SQL to do so:

update dyextn_containers set deleted_on = null where identifier = 86;

After this, the form will reappear in the form list. Follow the steps in the section below to retrieve the data for the records.

When form is detached

CASE 1: Below steps will be performed when the form is not reattached.

Check the identifier (attachment ID) of the form in the form context table.

select * from catissue_form_context where container_id=86;

The output of the command would be like below:

There is a deleted_on date added, which needs to be blanked out.

update catissue_form_context set deleted_on = null where identifier = 29;

This will restore the form attachment level and the records as well.

CASE 2: The form was detached and reattached again, the user performed data entry after reattaching the form. There will some records pointing to the older ID and some to the new ID. We need to update the older records to point to the new form of attachment.

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

select xml from dyextn_containers where caption = 'Chemotherapy form';

The output would be the form XML file along with the form ID and database table name in which the form records are stored. Eg: 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>.......

Check the total number of records present in the DE_E_11006 table.

SELECT count(*) from DE_E_11006;

The number of records is 

Check the latest from the context identifier of the form.

select * from catissue_form_context where container_id=86;

The output of the command would be like below: The older form ID was 29 and the new one (when the form was reattached) is 30.

Check the number of records present for both the IDs

select * from catissue_form_record_entry where form_ctxt_id = 29;

There are 10 records from the older entry

For ID 30,

select * from catissue_form_record_entry where form_ctxt_id = 30;

There are 15 records from the new entry

After moving the records from old to the new ID, the sum should be the same as that in the database DE table.

select count(*) from catissue_form_record_entry where form_ctxt_id = 29 and activity_status='Active' limit 5;

The output of the above command.

Need to move all the records 

update catissue_form_record_entry set form_ctxt_id = 30 where form_ctxt_id = 29;

Get the 

select count(*) from catissue_form_record_entry where form_ctxt_id = 30 and activity_status='Active';

The count should be 25