Hi,
Is it possible to view all saved Drafts as an Admin? Based on my search, it seems that this feature was requested but there are no replies beyond that.
Is the information store somewhere in the database? Can we query it out?
Hi,
Is it possible to view all saved Drafts as an Admin? Based on my search, it seems that this feature was requested but there are no replies beyond that.
Is the information store somewhere in the database? Can we query it out?
I'm not aware of how to view it in Forms.
The values in the database exist in the cf_form_submissions table.
This query should get you started (note - this doesn't limit to just open processes - this will show every draft submission in your database history).
SELECT submissions.submission_id, submissions.draft_name, submissions.draft_email, submissions.draft_contains, submissions.draft_pwd, processes2.name, steps.name, submissions2.date_created, users.username FROM [LFForms].[dbo].[cf_form_submissions] AS submissions LEFT JOIN [LFForms].[dbo].[cf_submissions] AS submissions2 ON submissions2.submission_id = submissions.submission_id LEFT JOIN [LFForms].[dbo].[cf_bp_processes] AS processes ON processes.process_id = submissions.process_id LEFT JOIN [LFForms].[dbo].[cf_business_processes] AS processes2 ON processes2.bp_id = processes.bp_id LEFT JOIN [LFForms].[dbo].[cf_bp_steps] AS steps ON steps.step_id = submissions.step_id AND steps.process_id = submissions.process_id LEFT JOIN [LFForms].[dbo].[cf_user_snapshot] AS users ON users.id = submissions2.user_snapshot_id WHERE submissions.draft_name IS NOT NULL ORDER BY submissions.submission_id
Where is the form is this located? is it on the forms are like CSS/Java? I am still earning some of the features since taking over in July 2019
Process admin can manage the drafts with Forms 11 Update 2, see https://support.laserfiche.com/kb/1014352/list-of-changes-for-laserfiche-forms-11-update-2