Hi everyone! I need to add WHERE IN condition to the query like this: `WHERE IN ({{ workspace_vendors_query.data.id }})` where workspace_vendors_query.data.id are the ids of the table "WorkspaceVendors" How can I do that? Currently, I’m receiving error like this: invalid input syntax for integ…

How to query PSQL using WHERE IN

gabriel.santos September 29, 2021, 4:10pm 2

Hi John, try to use

Where = ANY ({{ workspace_vendors_query.data.id}})

3 Likes

Topic		Replies	Views
Using SQL IN statement within Query Library 💬 Queries and Resources	4	592	September 17, 2024
How to add comma separated values from text component to query's "IN" 💬 Queries and Resources sql	2	3259	August 2, 2023
Array in where clause IN() 💬 Queries and Resources	3	329	October 28, 2024
How do I use a JS array from a SQL query result in a second query's WHERE IN clause? 💬 Queries and Resources javascript , postgres	5	7108	August 2, 2023
Passing integer values using additionalScope to SQL IN clause 💬 Queries and Resources sql , additionalscope	3	1551	June 10, 2023