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

Question

Question

Work flow and database update

asked on November 26, 2020

I have a workflow that fills and triggers Laserfiche Forms' business process( as shown below) , I need to flag the data in SQL database every time the workflow is triggered so I don't take the same data twice.

Business scenario : -
I fill the form based on the Vendor account and the workflow gets its corresponding data, when I add more records in the SQL database for the same vendor account I want to get the none flagged records only.


0 0

Replies

replied on November 26, 2020

You would likely need to add another field to your DB that you would update or see if it was updated so you exclude those items during the initial query but adding to your query that that field is Null or contains a date, et (Not knowing what else is happening to your DB table).

If you have control over the DB table, in your current process you would add an Update DB and through a loop have it update that fields that you are going to use in your form start to with "In Progess". When your Invoked Form Process was completed you would have another workflow that would set the values to "Completed".

Just some thoughts

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

Sign in to reply to this post.