Postgres: Filter Using Boolean Expressions
Filter based on failure of some criteria (_not)
The _not
operator can be used to fetch results for which some condition does not hold true. i.e. to invert the filter
set for a condition.
Example: _not
Fetch all authors who don't have any published articles:
Using multiple filters in the same query (_and, _or)
You can group multiple parameters in the same where
argument using the _and
or the _or
operators to filter results
based on more than one criteria.
You can use the _or
and _and
operators along with the _not
operator to create arbitrarily complex boolean
expressions involving multiple filtering criteria.
Example: _and
Fetch a list of articles published in a specific time-frame (for example: in year 2017):
Certain _and
expressions can be expressed in a simpler format using some syntactic sugar. See the
API reference for more details.
Example: _or
Fetch a list of articles rated more than 4 or published after "01/01/2018":
The _or
operator expects an array of expressions as input. If an object is passed as input it will behave like the
_and
operator as explained in the API reference