Hi team Retool, I'm trying to pass a list of values from a retool table component, into a SQL statement, so that information can be selected from a SQL table: [image] To make sure I'm getting the right values, I'm using a JS transformer, then referencing those values in the SQL statement: [ima…

Slightly weird follow up. I changed the layout of the Query SQL with JSON - and now I dont get the error: [image] I dont know why it works without error this way - but it does, so I'll take it. Thanks Nina.

Use a list of values from a table in a SQL IN statement

Nina August 19, 2023, 12:07am 5

Use a list of values from a table in a SQL IN statement