Select query from an array result return by js

[luan_d_ng]

i want to select from an id array return by js code. How can i achieve that?

[AnsonHwang]

Hello, here is my code for you refer.
query10

SELECT * FROM "Shipments" WHERE id in ( {{query8.data.map(it=>`'${it}'`).join(",")}} )

query8

[kristin]

Hello,
In Postgres queries, I often use =ANY({{array_variable}}). I found this stack overflow response's explanation of IN vs. ANY to be pretty helpful. sql - IN vs ANY operator in PostgreSQL - Stack Overflow

[luan_d_ng]

it works for me. Many thanks