Replacement Variable

White Belt

Replacement Variable

I'm using workbench 5 and my current query looks like 


SELECT Unique_ID, Incident_Date, Incident_Time, Incident_Description

FROM Incidents

WHERE Unique_ID > !{lastvalue:Unique_ID}!



In my replacement variables, I have the column set as "Unique_ID"  and the value as "!{lastvalue:Unique_ID}!

I've run this query using both the append and the replace update method and everytime it gets stuck returning the message "Replacing Last Value query at position 146" 3 - 5 times a second, sometimes freezing workbench altogether. What am I doing wrong? How do I get the job to run successfully and update the value in my replacement variable?  

Major Brown Belt

Re: Replacement Variable

Hi there,


The information you are looking for is in this link;

Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!