JavaScript: Match at least one filter

Match only rows which satisfy at least one of the filters.

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

.or('id.in.(5,6,7), arraycol.cs.\{"a","b"\}')  // Use `()` for `in` filter, `\{\}` for array values and `cs` for `contains()`.
.or('id.in.(5,6,7), arraycol.cd.\{"a","b"\}')  // Use `cd` for `containedBy()`

Parameters

• filters

  (Required)

  The filters to use, following PostgREST syntax

• options

  (Required)

  Named parameters

Examples

With `select()`

const \{ data, error \} = await supabase
  .from('countries')
  .select('name')
  .or('id.eq.2,name.eq.Algeria')

Use `or` with `and`

const \{ data, error \} = await supabase
  .from('countries')
  .select('name')
  .or('id.gt.3,and(id.eq.1,name.eq.Afghanistan)')

Use `or` on referenced tables

const \{ data, error \} = await supabase
  .from('countries')
  .select(`
    name,
    cities!inner (
      name
    )
  `)
  .or('country_id.eq.1,name.eq.Beijing', \{ referencedTable: 'cities' \})