Retool Workflow SQL Queries with Where Clauses Failing

Workflows
,
1

image
image1860×970 134 KB

image
image869×939 106 KB

image
image1640×933 76.5 KB

I am facing issues with retool workflows where every single workflow where I have a SQL query with a Where clause is failing.

2

Hello @Tushar_Nair,

Try wrapping the double brackets in quotes.

ANY('{{companyFetchQueryData.data}}'::int[])

Same for the other queries.

Let me know if this helps!

3

Thank you @GuilhermeSilva that does fix it but I am trying to understand what changed? I have 10s of worklfows including the ones in the screenshots that were working just fine without the double bracket quotes.

1 Like
4

It depends on the DB type and set up, some examples of ' ' being needed are when prepared statements are turned on on sql or when using snowlake or other DB languages as it is SQL but a variation of it.
Even in apps doing a simple query like the following sometimes requires brackets: select * from user where id = '{{currentUser.id}}'