(Couldn't find a post on this, but I apologize if there is already one out there.)
To speed up my queries, I have been trying to filter my data earlier in my workflows by...
The WHERE clauses in particular really seem to help, so I have been trying to use more of them, but I have noticed that they do not seem to work when I am specifying rows with a string instead of a number:
Does anyone know why that is, or how I can troubleshoot this error?
Solved! Go to Solution.
Hi @Skylar
Can you try single-quotes around the string? Depending on the database, that might help.
- John
Should have thought of that--that worked!
That is going to be a huge time saver for us and should take a considerable load off of the database. It stores all transactions in the same table, so being able to filter within the "Input Data" tool will be a big help.
Thanks!