QueryOperator

Comparison and filtering operators used in query conditions.

Index

Enumeration Members

• $contained
• $contains
• $elemMatch
• $eq
• $every
• $exists
• $fulltext
• $gt
• $gte
• $hasKey
• $hasKeys
• $hasSomeKeys
• $ilike
• $in
• $like
• $lt
• $lte
• $ne
• $nin
• $none
• $not
• $overlap
• $re
• $size
• $some

Enumeration Members

$contained

$contained: <@

Array/JSON contained-by operator (PostgreSQL only).

$contains

$contains: @>

Array/JSON contains operator (PostgreSQL only).

$elemMatch

$elemMatch: elemMatch

Matches an element inside a JSON array (SQL only).

$eq

$eq: =

Equal.

$every

$every: every

Every element in the collection matches (SQL only).

$exists

$exists: not null

Checks that the value is not null (i.e., exists).

$fulltext

$fulltext: fulltext

Full-text search.

$gt

$gt: >

Greater than.

$gte

$gte: >=

Greater than or equal to.

$hasKey

$hasKey: ?

JSON object has the given key (PostgreSQL only).

$hasKeys

$hasKeys: ?&

JSON object has all of the given keys (PostgreSQL only).

$hasSomeKeys

$hasSomeKeys: ?|

JSON object has at least one of the given keys (PostgreSQL only).

$ilike

$ilike: ilike

Case-insensitive LIKE (PostgreSQL only).

$in

$in: in

Included in the given list.

$like

$like: like

SQL LIKE pattern matching.

$lt

$lt: <

Less than.

$lte

$lte: <=

Less than or equal to.

$ne

$ne: !=

Not equal.

$nin

$nin: not in

Not included in the given list.

$none

$none: none

No element in the collection matches (SQL only).

$not

$not: not

Negation wrapper.

$overlap

$overlap: &&

Array overlap operator (PostgreSQL only).

$re

$re: regexp

Regular expression matching.

$size

$size: size

Matches collections by their size (SQL only).

$some

$some: some

At least one element in the collection matches (SQL only).