Hello -

We have a case where we have a forms business process (an application for services) that goes from a public user submission, to an internal review form and then to an internal final approval/denial form.  Many of the fields are reused as it passes to the next form in the process.  We started out with a field "City" that was just a text field with suggested entries.  After some time and seeing lots of data cleanup issues, we decided to create a new City field using a drop-down list.

Well a mistake was made and the original City variable was deleted--thus erasing all prior completed and in-progress data.  We have an export of all data just before that variable was deleted, but we would like to know if there is a way to repopulate the new City field for completed instances through SQL for ongoing reporting purposes.

We have a raw data export file with Instance IDs and the city field we can iterate through, but is there a SQL statement we can use to accomplish this?  We are only looking to repopulate the City data for the completed instances.

Has something like this been done before?  Currently using 10.4 Rio.

Thank you in advance for your guidance on this.