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

Question

Question

How to pause workflow for user interaction

asked on July 18, 2019 Show version history

I am looking for an example of a Workflow in Workflow Designer that pauses the workflow started by a forms process.  What I am looking for is a method to pause the workflow if a DB query does not return any results, until a technician has an opportunity to research the reason an initial record was not inserted in a previous step.  I initially thought of using a "Wait for Entry Change" task as seen in the screenshot but am unable to figure out how to configure it as I am not storing the form in the repository there is limited options for change.  I am looking for a better way to create a delay that is not a set amount of time.  Any ideas are welcome. 

 

For those of you that will ask why I am not waiting till I have all the information to be inserted, I am using the queried index in a dynamically generated URL emailed to an employee following the update step and if I do an insert followed by a query to get the record index they always fail due to the SQL server does not finish writing the record before the query hits.  This workflow has been working flawlessly for over a year, the past 2 days it has started to fail intermittently and that is the reason I an needing the delay and notification it to determine what has changed in our infrastructure to cause the problem.

table insertion then index query prior to updating..PNG
0 0

Replies

replied on July 19, 2019

Workflow can only wait on user actions on documents in the repository.

However, you can pass data back to the Forms process and have it deal with notifying a user and waiting for them to take action. Set Business Process Variables activity handles that communication. Be aware that this activity only sends data back to Forms when the Workflow instance completes, so in your "If record not found notify Kip" Conditional Sequence you'll want to add an End Workflow activity. Once you figure out what's going on you can complete the user task in Forms and have your process route back to the service task that calls Workflow to run this instance again.

The quick and dirty way to do this, if it's just a matter of investigating what's going on right now, would be to add a delay of 2-4 hours after you email yourself about it to give you time to look into it. This is simpler, but not as safe if this happens over the weekend or when you don't have time to immediately look into it.

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

Sign in to reply to this post.