I have tried every suggestion I've found on the community as well as the greater google-verse, but I still can't figure out how to create a WHERE statement with an array of values from a selection. Here's the query with it typed out (which works!): [image] And here is the selector: [image] And…

Hey @mathfour You can see previous answer here and again in docs . [image] This looks to be working. Give it a try? [image]

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

Nina April 18, 2023, 3:16am 2

Hey @mathfour
You can see previous answer here and again in docs.

This looks to be working. Give it a try?

Use a list of values from a table in a SQL IN statement

Topic		Replies	Views
Trying to query a JSON array with multiple values 💬 App Building pool-party	6	985	July 25, 2024
Multi-Select fails with redshift queries prepared statements 💬 Queries and Resources	15	5204	July 27, 2023
Using IN( {{array}} ) from a JSON with SQL query 💬 Queries and Resources	10	10426	August 2, 2023
Multiselect value in snowflake query doesn't work 💬 Queries and Resources	6	2322	August 1, 2023
Conditional Select 💬 Queries and Resources	15	9680	June 18, 2024