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.