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…

Hi John, try to use Where = ANY ({{ workspace_vendors_query.data.id}})

How to query PSQL using WHERE IN

johndiaz September 29, 2021, 8:33pm 3

Hi Gabriel. Wow, this worked! Thank you so much for the suggestion!

2 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