JavaScript: Match at least one filter

• .or() expects you to use the raw PostgREST syntax for the filter names and values.

  .or('id.in.(6,7), arraycol.cs.\{"a","b"\}')  // Use Postgres list () for in filter. Array \{\} for array column and 'cs' for contains.
  .or(`id.in.($\{arrList\}),arraycol.cs.\{$\{arr\}\}`)	// You can insert a javascipt array for list or array on array column.
  .or(`id.in.($\{arrList\}),rangecol.cs.[$\{arrRange\})`)	// You can insert a javascipt array for list or range on a range column.
  

Examples

With `select()`

const \{ data, error \} = await supabase
  .from('cities')
  .select('name, country_id')
  .or('id.eq.20,id.eq.30')

Use `or` with `and`

const \{ data, error \} = await supabase
  .from('characters')
  .select('name, book_id')
  .or('id.gt.20,and(name.eq.Harry,name.eq.Frodo)')

Use `or` on foreign tables

const \{ data, error \} = await supabase
  .from('books')
  .select('id, characters(*)')
  .or('name.eq.Luke,name.eq.Leia', \{ foreignTable: "characters" \})