IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
Exists queryedit
Returns documents that contain a value other than null
or []
in a provided
field.
Example requestedit
GET /_search { "query": { "exists": { "field": "user" } } }
Top-level parameters for exists
edit
-
field
-
(Required, string) Name of the field you wish to search.
To return a document, this field must exist and contain a value other than
null
or[]
. These values can include:-
Empty strings, such as
""
or"-"
-
Arrays containing
null
and another value, such as[null, "foo"]
-
A custom
null-value
, defined in field mapping
-
Empty strings, such as
Notesedit
Find documents with null valuesedit
To find documents that contain only null
values or []
in a provided field,
use the must_not
boolean query with the exists
query.
The following search returns documents that contain only null
values or []
in the user
field.
GET /_search { "query": { "bool": { "must_not": { "exists": { "field": "user" } } } } }