Hello, I currently have a Retool Database Query that goes SELECT * FROM driver WHERE name IN ({{driverSelectValues.data}}) The driverSelectValues is a JavaScript that goes const selectedValues = multiselectListbox1.selectedLabels.map(value => `'${value}'`).join(','); console.log(selectedValues)…

Hello! I think this one way to get around the limitations of the IN clause: [image] Use variable in query without doble quote Queries and Resources Hello everyone ! I currently used a variable in my query with an IN clause, so my variable is in my case a sequence of wor…

Retool Database and JavaScript Query Data

💬 Queries and Resources

pyrrho March 7, 2024, 10:13pm 4

Hello!

I think this one way to get around the limitations of the IN clause:

There is an additional link to another post that goes into further detail.

Topic		Replies	Views
Use variable in query without doble quote 💬 Queries and Resources sql	3	2071	November 20, 2023
Double Quotes Array in MultiSelect and Postgres Filter 💬 Queries and Resources	12	3402	September 24, 2024
Using Javascript to generate postgres query fragments 💬 Queries and Resources	4	821	November 13, 2023
MSSQL WHERE IN returns no results 💬 Queries and Resources	4	646	August 3, 2023
How to create a dynamic query without changing resource settings? 💬 Queries and Resources sql	10	7101	August 3, 2023

Retool Database and JavaScript Query Data

Related topics