Hi, Having an issue with a SQL select statement, when trying to pass a list of values from a Javascript transformer. If I select only 1 row in a table, the query works perfectly. [image] However, if I try selecting more than 1 value, I get the following error: message:"Conversion failed when …

Passing selected table values to a SQL IN statement

Tess December 8, 2023, 9:21pm 3

Hi there! This post has some helpful examples for working with arrays in Retool SQL queries

Topic		Replies	Views
Array in where clause IN() 💬 Queries and Resources	3	1106	October 28, 2024
Passing Values to SQL queries not working 💬 Workflows	3	68	February 17, 2026
Getting IN() function to work from multiselect table with Azure/SQL server 💬 Queries and Resources	8	3383	August 2, 2023
SQL Query not working with transformer input 💬 Queries and Resources	9	162	November 29, 2024
MySQL IN() Clause with array 💬 Queries and Resources mysql	2	10525	August 1, 2023