# Not able to fetch 2 level nested data in elasticsearch

**URL:** <https://discuss.elastic.co/t/not-able-to-fetch-2-level-nested-data-in-elasticsearch/83996>\
**Category:** Elasticsearch\
**Created:** [April 28, 2017, 10:10am UTC](https://discuss.elastic.co/t/not-able-to-fetch-2-level-nested-data-in-elasticsearch/83996 "2017-04-28T10:10:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![abhishek5678](https://avatars.discourse-cdn.com/v4/letter/a/5daacb/32.png) [@abhishek5678](https://discuss.elastic.co/u/abhishek5678)\
**Post date:** [April 28, 2017, 10:10am UTC](https://discuss.elastic.co/t/not-able-to-fetch-2-level-nested-data-in-elasticsearch/83996/1 "2017-04-28T10:10:41Z")

</div>

I am also running the same nested example but it's not [working.In](http://working.In) this data when i am trying with one level nested data then it's working fine but when i am adding one more nested data then it's not working if anybody will be knows about that then please reply me.I am sending my document data and mapping file also.

PUT /icd10\_codes  
{  
"mappings": {  
"doc": {  
"properties": {  
"name": { "type": "string" },  
"depth": {"type":"long"},  
"children": {  
"type": "nested",  
"properties": {  
"name": { "type": "string" },  
"depth": { "type": "long" },  
"children": {  
"type": "nested",  
"properties": {  
"code": { "type": "string" },  
"name": { "type": "string" },  
"depth": { "type": "long" }  
}  
}  
}  
}  
}  
}  
}  
}

POST /icd10\_codes/doc/1  
{  
"name": "Diseases of the blood and blood-forming organs and certain disorders involving the immune mechanism (D50-D89)",  
"depth": 1,  
"children": [{  
"name": "Nutritional anemias (D50-D53)",  
"depth": 2,  
"children": [{  
"code": "D50.0",  
"name": "Iron deficiency anemia secondary to blood loss (chronic)",  
"depth": 4  
}, {  
"code": "D50.1",  
"name": "Sideropenic dysphagia",  
"depth": 4  
}, {  
"code": "D50.8",  
"name": "Other iron deficiency anemias",  
"depth": 4  
}, {  
"code": "D50.9",  
"name": "Iron deficiency anemia, unspecified",  
"depth": 4  
}]  
}]  
}

please tell me what is the query i am applying here.i applied the query like this:  
GET /icd10\_codes/doc/\_search?\_source=false  
{  
"query": {  
"nested": {  
"path": "children",  
"query": {  
"bool": {  
"must": [  
{  
"match": {  
"[children.name](http://children.name)": "Nutritional anemias (D50-D53)"  
}  
},  
{  
"nested": {  
"path": "children.children",  
"query": {  
"match": {  
"[children.children.name](http://children.children.name)": "Sideropenic dysphagia"  
}  
}  
}  
}  
]  
}  
}  
}  
},  
"inner\_hits": {  
"kids": {  
"path": {  
"children": {  
"query": {  
"match": {  
"[children.name](http://children.name)": "Nutritional anemias (D50-D53)"  
}  
},  
"inner\_hits": {  
"grand\_kids": {  
"path": {  
"children.children": {  
"query": {  
"match": {  
"[children.children.name](http://children.children.name)": "Sideropenic dysphagia"  
}  
}  
}  
}  
}  
}  
}  
}  
}  
}  
}

---

<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:** [May 26, 2017, 10:26am UTC](https://discuss.elastic.co/t/not-able-to-fetch-2-level-nested-data-in-elasticsearch/83996/2 "2017-05-26T10:26:06Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.