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…

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

Kabirdas September 15, 2022, 1:00am 5

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.

1 Like

Query JSON with SQL Select doesn't allow for conditional statement with arrays

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

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

Related topics