Flutter: Column contains every element in a value

Only relevant for jsonb, array, and range columns. Match only rows where column contains every element appearing in 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

final data = await supabase
  .from('issues')
  .select()
  .contains('tags', ['is:open', 'priority:low']);

On range columns

final data = await supabase
  .from('reservations')
  .select()
  .contains('during', '[2000-01-01 13:00, 2000-01-01 13:30)');

On `jsonb` columns

final data = await supabase
  .from('users')
  .select('name')
  .contains('address', \{ 'street': 'Melrose Place' \});