Hi Team,

I'm trying to grab all the data that was submitted in a form much after it has been submitted. None of the field values were stored into metadata, so i am trying to see if i can pull it from the Forms SQL table.


I was able to find the field data in the SQL table cf_bp_data under the value column. This table also has submission_id in it. So if I could get the submission ID from my current tiff, i'd be in business, not I never pulled the submission id when saving to repo. So question #1, is there anyway to get the submission_id? maybe from entry id?

Other option:
I was able to save the instance_id in the metadata and I found a table called cf_bp_worker_instance_history, which has information on instance_id and submission_id. In theory I can use this table to map my instance_id to a submission_id, then use that submission_id to pull up the field values. However it did not work because I was getting a different instance_id in SQL than what was saved in the metadata. Am i looking at the wrong tables here? Thanks for any help.