👋 can anyone help me figure out how to filter a query based on a value in a text array using the supabase-js library? In the code below, the

title

column is

text

and

tags

column is

text[]

. I would like to query them both using the

or

filter to see if a given

searchTerm

was there. Is this possible?

js
const response = await supabaseClient
  .from('items')
  .select('*')
  .or(
    `title.ilike.%${searchTerm}%,tags.cs{${searchTerm}}`
  )

The above example does not work.. any ideas

I think you need a . after cs before {

like this

tags.cs.{${searchTerm}}

?