Basic Usage

Matches documents containing a specified term.

field
required

Specifies the field within the document to search for the term. If omitted, all indexed fields will be searched.

value
required

Value to search for in the document field.

Numeric, boolean, or datetime fields can also be passed into the term query.

Enumerated Types

term can be used to filter over custom Postgres enums if the query term is explicitly cast to the enum type. If JSON syntax is used, the underlying ordinal value of the enum must be used.