You are viewing limited content. For full access, please sign in.

Question

Question

View all saved Drafts as an Admin

asked on August 29, 2019

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?

0 0

Replies

replied on September 27, 2019

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 

 

1 0
replied on December 5, 2019

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

0 0
replied on May 23, 2022

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

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.