Hey @snowman! Can you share what db type (postgres, mysql, etc) you are using? We have a great post here that helps explain some of the different syntaxes required when using arrays in SQL in Retool. The final solution here is likely dependent on the db type.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Problem working with arrays in Retools Database | 4 | 1712 | October 5, 2023 | |
| Multiselect.value returns an object instead of an array | 1 | 969 | March 5, 2023 | |
| MultiSelect in SQL query is not working | 6 | 54 | February 6, 2025 | |
| How to insert multiselect values as array in PostgreSQL? | 2 | 846 | March 8, 2024 | |
| Multiselect value in snowflake query doesn't work | 6 | 2218 | August 1, 2023 |