IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
Exists query
editExists query
editReturns documents that contain a value other than null
or []
in a provided
field.
Example request
editGET /_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
Notes
editFind documents with null values
editTo 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" } } } } }