Hey, I want to create a MultiSelect Dropdown Menu that filters a table in Retool. I want to filter the Postgres Query witht the Where column IN ({{...}}) statement. Unfortunately the Dropdown (which is also loaded by a database column) returns the array values in the array format with double quotes…

Double Quotes Array in MultiSelect and Postgres Filter

everett_smith October 19, 2022, 11:30pm 8

Hey @redfiel3, Does SELECT DISTINCT party from main where reg_state = ANY ({{multiselect1.value}}) work on your end?

Using 'ANY' with MS SQL

Topic		Replies	Views
Multi-Select fails with redshift queries prepared statements 💬 Queries and Resources	15	5232	July 27, 2023
How to create a dynamic query without changing resource settings? 💬 Queries and Resources sql	10	7146	August 3, 2023
Malformed array literal 💬 Queries and Resources	5	5899	August 2, 2023
SQL bind error, 6 parameters but requires 0 💬 Queries and Resources	12	9299	August 2, 2023
Using Javascript to generate postgres query fragments 💬 Queries and Resources	4	838	November 13, 2023