IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Range Query Prefix Query »
Elastic Docs ›Elasticsearch Guide [5.3] ›Query DSL ›Term level queries

Exists Query

edit

Exists Query

edit

Returns documents that have at least one non-null value in the original field:

GET /_search
{
    "query": {
        "exists" : { "field" : "user" }
    }
}

For instance, these documents would all match the above query:

{ "user": "jane" }
{ "user": "" } 
{ "user": "-" } 
{ "user": ["jane"] }
{ "user": ["jane", null ] }

An empty string is a non-null value.

Even though the standard analyzer would emit zero tokens, the original field is non-null.

At least one non-null value is required.

These documents would not match the above query:

{ "user": null }
{ "user": [] } 
{ "user": [null] } 
{ "foo":  "bar" }

This field has no values.

At least one non-null value is required.

The user field is missing completely.

null_value mapping

edit

If the field mapping includes the null_value setting then explicit null values are replaced with the specified null_value. For instance, if the user field were mapped as follows:

  "user": {
    "type": "keyword",
    "null_value": "_null_"
  }

then explicit null values would be indexed as the string _null_, and the following docs would match the exists filter:

{ "user": null }
{ "user": [null] }

However, these docs—​without explicit null values—​would still have no values in the user field and thus would not match the exists filter:

{ "user": [] }
{ "foo": "bar" }

missing query

edit

missing query has been removed because it can be advantageously replaced by an exists query inside a must_not clause as follows:

GET /_search
{
    "query": {
        "bool": {
            "must_not": {
                "exists": {
                    "field": "user"
                }
            }
        }
    }
}

This query returns documents that have no value in the user field.

« Range Query Prefix Query »