Page Comparison

Pre-requisites

The exact deleted field name and its type must be known.

Form name and form ID under which field is deleted must be known.

Steps to solve the problem: 

1. Get the form XML from the dyextn_containers table into a file using below SQL.

...

3. List down all present fields from UI of the form into a google sheet.

4. Now describe the table found in step#2. List down all database column names into a google sheet.

desc DE_E_11280;

5. Compare the columns listed in step #3 with those present in the database table (step #4 columns) for the form PDAC. The database will have more columns than those present in XML. The additional columns are the candidate columns which that were storing the data for the deleted field of the form.

...

Here you need to check data is present into the additional columns or not. If there are 10 additional columns, you need to run the below query 10 times with each column name and note down the count of records.

...

8. Add the missing field through UI. Give it the same name and type as the deleted oneones. This will create a new database column.

...

...