When a user selects the "Save unfinished for to complete later" checkbox, where is that data stored in the Forms database?
Question
Question
Answer
Draft submission is considered a submission to forms and uses some of the code paths of a real submission. Like all data it can be found in the cf_bp_data table. Look for the draft data by searching for all items with a certain submission_id. You can determine the submission id from the email. For example:
http://localhost/E-forms/Form/resume/14844/29053
means the submission id is 29053
SELECT * FROM [dbo].[cf_bp_data] where submission_id = 29053
Replies
The data is stored as a draft submission in a few tables, why do you want to access the draft forms?
Can you please tell me what tables those are? We are testing some processes and need to edit a few to get them to complete correctly.
Draft submission is considered a submission to forms and uses some of the code paths of a real submission. Like all data it can be found in the cf_bp_data table. Look for the draft data by searching for all items with a certain submission_id. You can determine the submission id from the email. For example:
http://localhost/E-forms/Form/resume/14844/29053
means the submission id is 29053
SELECT * FROM [dbo].[cf_bp_data] where submission_id = 29053
Have the drafts changed tables or are they still in the mentioned table? Thanks