Skip to main content
Version: next

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