Elastic request exists for attached documents

Question

I have attached documents:

"someField": "hello", "users": [ { "name": "John", "surname": "Doe", "age": 2 } ] 

according to this https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-exists-query.html , the above should match:

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

}

whereas it should not

 "someField": "hello", "users": [] 

but, unfortunately, both of them do not match. any ideas?

Answer 1

The example mentioned on the Elasticsearch blog is for strings and an array of string types, not nested types.

The following query should work for you:

 { "query": { "nested": { "path": "users", "query": { "bool": { "must": [ { "exists": { "field": "users" } } ] } } } } } 

Alternatively, you can address this issue for more information that discusses this usage pattern.

Answer 2

With the following index mapping:

 { "index_name": { "mappings": { "object_name": { "dynamic": "strict", "properties": { "nested_field_name": { "type": "nested", "properties": { "some_property": { "type": "keyword" } } } } } } } } 

I needed to use this query:

 GET /index_name/_search { "query": { "nested": { "path": "nested_field_name", "query": { "bool": { "must": [ { "exists": { "field": "nested_field_name.some_property" } } ] } } } } } 

Elastic Version 5.4.3

Answer 3

It works for me

 GET /type/_search?pretty=true { "query": { "bool": { "must": [ { "nested": { "path": "outcome", "query": { "exists": { "field": "outcome.outcomeName" } } } } ] } } }