filter method

PostgrestFilterBuilder<T> filter(String column, String operator, Object? value)

Finds all rows whose column satisfies the filter.

await supabase
    .from('users')
    .select()
    .filter('username', 'eq', 'supabot');

Implementation

PostgrestFilterBuilder<T> filter(
    String column, String operator, Object? value) {
  final Uri url;
  if (value is List) {
    if (operator == "in") {
      url = appendSearchParams(
        column,
        '$operator.(${_cleanFilterArray(value)})',
      );
    } else {
      url = appendSearchParams(
        column,
        '$operator.{${_cleanFilterArray(value)}}',
      );
    }
  } else {
    url = appendSearchParams(column, '$operator.$value');
  }
  return copyWithUrl(url);
}