# \[1.5\] Querying Nested docuement

**URL:** <https://discuss.elastic.co/t/1-5-querying-nested-docuement/57020>\
**Category:** Elasticsearch\
**Created:** [August 2, 2016, 2:31pm UTC](https://discuss.elastic.co/t/1-5-querying-nested-docuement/57020 "2016-08-02T14:31:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ugo\_Bourdon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ugo_bourdon/32/10725_2.png) [@Ugo\_Bourdon](https://discuss.elastic.co/u/Ugo_Bourdon)\
**Post date:** [August 2, 2016, 2:31pm UTC](https://discuss.elastic.co/t/1-5-querying-nested-docuement/57020/1 "2016-08-02T14:31:42Z")

</div>

How can i request document with nested field ?

My mapping :

`{ "pi_idxtickets": { "mappings": { "ticket": { "properties": { "providers": { "type": "nested", "properties": { "name": { "type": "string" }, "uid": { "type": "string", "index": "not_analyzed" } } } } } } } }`

My request :

`{ "from" : 0, "size" : 100, "query" : { "filtered" : { "query" : { "bool" : { "must" : { "terms" : { "providers.uid" : ["24e2e58c-109f-857f-aaa6-378b7eb26092"] } } } }, "filter" : { "bool" : { "must" : { "match_all" : { } } } } } }`

But that don't works. Any idea ? Thx.

---

<div class="post-metadata">

**Author:** ![Ugo\_Bourdon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ugo_bourdon/32/10725_2.png) [@Ugo\_Bourdon](https://discuss.elastic.co/u/Ugo_Bourdon)\
**Post date:** [August 2, 2016, 3:10pm UTC](https://discuss.elastic.co/t/1-5-querying-nested-docuement/57020/2 "2016-08-02T15:10:17Z")

</div>

I try this request :

`{"from":0,"size":100,"query":{"filtered":{"query":{"bool":{"must":{"nested":{"query":{"terms":{"providers.uid":["24e2e58c-109f-857f-aaa6-378b7eb26092"]}},"path":"providers.uid"}}}},"filter":{"bool":{"must":{"match_all":{}}}}}},"sort":[{"updated":{"order":"desc"}}]}`

But that return me error response because i have some doc where providers is empty. Any idea how to deal with that ?

---

<div class="post-metadata">

**Author:** ![Ugo\_Bourdon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ugo_bourdon/32/10725_2.png) [@Ugo\_Bourdon](https://discuss.elastic.co/u/Ugo_Bourdon)\
**Post date:** [August 2, 2016, 3:26pm UTC](https://discuss.elastic.co/t/1-5-querying-nested-docuement/57020/3 "2016-08-02T15:26:40Z")

</div>

Ok i find my mistake. path parameter should be setted with providers and not with providers.uid.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 10:30pm UTC](https://discuss.elastic.co/t/1-5-querying-nested-docuement/57020/4 "2017-07-05T22:30:43Z")

</div>