JavaScript: Contained by value

Only relevant for jsonb, array, and range columns. Match only rows where every element appearing in column is contained by value.

Parameters

• column

  (Required)

  The jsonb, array, or range column to filter on

• value

  (Required)

  The jsonb, array, or range value to filter with

Examples

On array columns

const { data, error } = await supabase
  .from('classes')
  .select('name')
  .containedBy('days', ['monday', 'tuesday', 'wednesday', 'friday'])

On range columns

const { data, error } = await supabase
  .from('reservations')
  .select()
  .containedBy('during', '[2000-01-01 00:00, 2000-01-01 23:59)')

On `jsonb` columns

const { data, error } = await supabase
  .from('users')
  .select('name')
  .containedBy('address', {})