Postgres: Filter Using JSONB Objects
Introduction
The _contains
, _contained_in
, _has_key
, _has_keys_any
and _has_keys_all
operators are used to filter based on
JSONB
columns.
For more details on JSONB operators and Postgres equivalents, refer to the API reference.
_contains
Fetch all authors living within a particular pincode (present in address
JSONB column):
GraphiQL
Query Variables
Request Headers
No Schema Available
_contained_in
This example fetches all items where the "Tags" property contains the value "tag1" and is also contained in the list
["tag1", "tag2"]
.
GraphiQL
Query Variables
Request Headers
No Schema Available
_has_key
Fetch authors if the phone
key is present in their JSONB address
column:
GraphiQL
Query Variables
Request Headers
No Schema Available
_has_keys_any
Fetch users who have either "admin" or "editor" permissions:
GraphiQL
Query Variables
Request Headers
No Schema Available
_has_keys_all
Fetch user, where their id is "123", and check if the address has all the fields "street", "city", "state", "zip":
GraphiQL
Query Variables
Request Headers
No Schema Available