Exists query
editExists query
editReturns documents that contain an indexed value for a field.
An indexed value may not exist for a document’s field due to a variety of reasons:
-
The field in the source JSON is
null
or[]
-
The field has
"index" : false
and"doc_values" : false
set in the mapping -
The length of the field value exceeded an
ignore_above
setting in the mapping -
The field value was malformed and
ignore_malformed
was defined in the mapping
Example request
editresp = client.search( query={ "exists": { "field": "user" } }, ) print(resp)
response = client.search( body: { query: { exists: { field: 'user' } } } ) puts response
res, err := es.Search( es.Search.WithBody(strings.NewReader(`{ "query": { "exists": { "field": "user" } } }`)), es.Search.WithPretty(), ) fmt.Println(res, err)
const response = await client.search({ query: { exists: { field: "user", }, }, }); console.log(response);
GET /_search { "query": { "exists": { "field": "user" } } }
Top-level parameters for exists
edit-
field
-
(Required, string) Name of the field you wish to search.
While a field is deemed non-existent if the JSON value is
null
or[]
, these values will indicate the field does exist:-
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 missing indexed values
editTo find documents that are missing an indexed value for a field,
use the must_not
boolean query with the exists
query.
The following search returns documents that are missing an indexed value for
the user.id
field.
resp = client.search( query={ "bool": { "must_not": { "exists": { "field": "user.id" } } } }, ) print(resp)
response = client.search( body: { query: { bool: { must_not: { exists: { field: 'user.id' } } } } } ) puts response
const response = await client.search({ query: { bool: { must_not: { exists: { field: "user.id", }, }, }, }, }); console.log(response);
GET /_search { "query": { "bool": { "must_not": { "exists": { "field": "user.id" } } } } }