When I want to use an IN() with an array or a comma delimited list of values, for instance using a multi Select component, I would structure my WHERE clause like this: status_id in (SELECT value FROM STRING_SPLIT({{bgStatus.value}}, ',')) But this does not work with AlaSQL, STRING_SPLIT is not a r…

Hey @bradlymathews ! Can you try status_id in @({{bgStatus.value}}) and let us know if that works? AlaSQL has some specific syntax for approximating JavaScript in various cases that may be worth checking out.

Using IN( {{array}} ) from a JSON with SQL query

💬 Queries and Resources

ScottR September 14, 2022, 11:54am 4

I never found a resolution using AlaSQL so I reverted back to direct query of data which I think you will have to do the same; unfortunately

Using API array result in Query

Topic		Replies	Views
JSON SQL Query, how to search inside of array field 💬 Queries and Resources query-json-with-sql	2	2871	August 2, 2023
Multi-Select fails with redshift queries prepared statements 💬 Queries and Resources	15	5385	July 27, 2023
Using an array from an input component to filter SQL Query 💬 Queries and Resources resource-connection , sql	4	2486	December 28, 2023
SQL Cheatsheet - best practices for different flavors of SQL syntax 🧑‍💻 Retool Tips & Tricks	0	13039	July 31, 2023
How to use the multiselect component 💬 App Building	16	274	April 17, 2025

Using IN( {{array}} ) from a JSON with SQL query

Related topics