I have developed a workflow that inserts two sets of time values for hours worked into an SQL database. This means we have two start times and two end times. An example would be as follows.
07:00 - 12:00 13:00 - 16:00
I have created a Custom Query for each begin and end time submission to submit the times to the database.
Each time has a metadata field in LaserFiche of startShift, endShift, startShift2, endShift2.
The workflow performs custom query 1, then moves on to custom query 2 if a value has been provided for startShift2 or endShift2.
When custom query 2 is ran, it is inserting the same data from customer query 1.
I have made sure that the queries are pulling data from the correct RetrieveFieldValues and have even changed the name of the parameters in the queries.
I have placed the queries into separate workflows with "End Workflow" options ; however, I still only get the values from startShift, and endShift for both queries.
On Custom Query 2, I have even removed the RetrieveValueFields for startShift and endShift.
I am completely lost how custom query 2 is still pulling the values for startShift and endShift.
Does anyone have any suggestions?