JSON SQL Query, how to search inside of array field

💬 Queries and Resources
1

I have the following query result:

image

I want to be able to search of all records that have "Brad" in that assigned array. I also want to be able to search for All results. I have a button group with a list of names. How do I do this in JSON SQL (which I just learned is actually an implementation of alaSQL)?

1 Like
2

Here is the query I came up with which seems to be working fine. Notice the reversal of the normal pattern of the IN operator.

select * from {{qryToDoSelect.data}}
where {{bgPeople.value === 'All' ? null : '1'}} IS NULL 
      OR {{bgPeople.value}} in assigned
order by complete, item_type