Question

Instance ID and Submission ID

Forms

Updated June 9, 2017

asked on June 9, 2017 • Show version history

Good Morning,

In a recent Laserfiche form, I mistakenly assigned Submission ID meta data to the uploaded file metadata instead of Instance ID. Is there a query that I can use to obtain Instance ID using Submission ID?

0 0

Replies

replied on June 9, 2017 • Show version history

If you look up the form instance in the Monitoring section, you can add a column for Instance ID. That is probably the easiest way to track it down.

0 0

replied on June 9, 2017

Hello Doug,

You can use Workflow to look in the table "dbo.cf_submissions" in the Forms database, use the Submission ID for the column submission_id to pull the appropriate Instance ID from the bp_instance_id column. After the information is queried, you can assign metadata. If you are able to segment all of the files that need this change, you can use a For Each Entry iteration loop to apply the appropriate metadata to all of them in one fell swoop. Just be careful when dealing with database tables (especially those in the Forms database) as you don't want to create more problems than you are fixing!

Best regards,

Adam

0 0

You are not allowed to follow up in this post.

Question

Question

Instance ID and Submission ID

Replies

Sign in to reply to this post.