Use multiple values from js array into a SQL in Retool
Posted on January 13, 2024
If you're a Retool user, here the tip to make a SQL query that uses in the WHERE clause one or multiple values that come from a multi-select component:
SELECT
*
from
"Table"
WHERE
category = ANY ({{ multiselect.value }})