PSQL Query Not Running Properly in Workflow

[jeevenugo]

Hi Everyone,

I'm trying to build a workflow and fetching some data from my Postgres table.
This is what my query looks like:

This is what it looks like after evaluating:

For some reason this returns nothing, but if I take this evaluated query into DataGrip and run it against my DB, it will return rows.

What is wrong with this?

Get Transaction Report.json (24.7 KB)

[jeevenugo]

See Below, my data grip results:

[WidleStudioLLP]

Hey @jeevenugo

Could you please try removing the double quotes from the query, so it reads t.transactiondate instead of t."transactiondate"?
Have you tried like this?

[jeevenugo]

Yup, tried that already.

[WidleStudioLLP]

Have you checked if prepared statements are enabled or not?
some times because of that its not working.

[jeevenugo]

I believe it is an issue with the brackets around the cardList
@Tess @Darren

[Tess]

Hi @jeevenugo Please see this doc: SQL Cheatsheet - best practices for different flavors of SQL syntax

Postgres uses = ANY() syntax in Retool

Assuming prepared statements are enabled and cardList is an array, it should work with just t.cardnumber = ANY({{startTrigger.data.cardList}})