Skip to main content
Version: 3.5.0

FilterOperatorEnum

Defined in: src/lib/enums/filter-operator.enum.ts:18

Enum representing the available filter operators for explicit operator filters

NestJS encodes these with the $ prefix at the wire level (filter.field=$operator:value); PostgREST translates them to its own prefix notation (col=eq.val, col=is.null, etc.). The enum values are intentionally the NestJS form; each driver's request strategy is responsible for mapping them into its own shape.

FTS, PLFTS, PHFTS, WFTS are PostgREST-native full-text search variants; they throw UnsupportedFilterOperatorError on every other driver that does not recognise them.

See​

Enumeration Members​

BTW​

BTW: "$btw"

Defined in: src/lib/enums/filter-operator.enum.ts:19


CONTAINS​

CONTAINS: "$contains"

Defined in: src/lib/enums/filter-operator.enum.ts:20


EQ​

EQ: "$eq"

Defined in: src/lib/enums/filter-operator.enum.ts:21


FTS​

FTS: "$fts"

Defined in: src/lib/enums/filter-operator.enum.ts:22


GT​

GT: "$gt"

Defined in: src/lib/enums/filter-operator.enum.ts:23


GTE​

GTE: "$gte"

Defined in: src/lib/enums/filter-operator.enum.ts:24


ILIKE​

ILIKE: "$ilike"

Defined in: src/lib/enums/filter-operator.enum.ts:25


IN​

IN: "$in"

Defined in: src/lib/enums/filter-operator.enum.ts:26


LT​

LT: "$lt"

Defined in: src/lib/enums/filter-operator.enum.ts:27


LTE​

LTE: "$lte"

Defined in: src/lib/enums/filter-operator.enum.ts:28


NOT​

NOT: "$not"

Defined in: src/lib/enums/filter-operator.enum.ts:29


NULL​

NULL: "$null"

Defined in: src/lib/enums/filter-operator.enum.ts:30


PHFTS​

PHFTS: "$phfts"

Defined in: src/lib/enums/filter-operator.enum.ts:31


PLFTS​

PLFTS: "$plfts"

Defined in: src/lib/enums/filter-operator.enum.ts:32


SW​

SW: "$sw"

Defined in: src/lib/enums/filter-operator.enum.ts:33


WFTS​

WFTS: "$wfts"

Defined in: src/lib/enums/filter-operator.enum.ts:34