Table of Contents

Class QueryFilter

Namespace
Supabase.Postgrest
Assembly
Supabase.Postgrest.dll
public class QueryFilter : IPostgrestQueryFilter
Inheritance
QueryFilter
Implements
Inherited Members

Constructors

QueryFilter(Operator, IPostgrestQueryFilter)

Constructor to enable NOT functionality

public QueryFilter(Constants.Operator op, IPostgrestQueryFilter filter)

Parameters

op Constants.Operator

Operation: Not.

filter IPostgrestQueryFilter

QueryFilter(Operator, List<IPostgrestQueryFilter>)

Constructor to enable AND and OR Queries by allowing nested QueryFilters.

public QueryFilter(Constants.Operator op, List<IPostgrestQueryFilter> filters)

Parameters

op Constants.Operator

Operation: And, Or

filters List<IPostgrestQueryFilter>

QueryFilter(string, Operator, FullTextSearchConfig)

Constructor for Full Text Search.

public QueryFilter(string property, Constants.Operator op, FullTextSearchConfig fullTextSearchConfig)

Parameters

property string

Column Name

op Constants.Operator

Operation: FTS, PHFTS, PLFTS, WFTS

fullTextSearchConfig FullTextSearchConfig

QueryFilter(string, Operator, IntRange)

Constructor for Range Queries.

public QueryFilter(string property, Constants.Operator op, IntRange range)

Parameters

property string
op Constants.Operator

Operator: Overlap, StrictlyLeft, StrictlyRight, NotRightOf, NotLeftOf, Adjacent

range IntRange

QueryFilter(string, Operator, object?)

Contractor to use single value filtering.

public QueryFilter(string property, Constants.Operator op, object? criteria)

Parameters

property string

Column name

op Constants.Operator

Operation: And, Equals, GreaterThan, LessThan, GreaterThanOrEqual, LessThanOrEqual, NotEqual, Is, Adjacent, Not, Like, ILike

criteria object

Fields

NullVal

String value to be substituted for a null criterion

public const string NullVal = "null"

Field Value

string

Properties

Criteria

public object? Criteria { get; }

Property Value

object

Op

public Constants.Operator Op { get; }

Property Value

Constants.Operator

Property

public string? Property { get; }

Property Value

string