# Help me to query this document

**URL:** <https://discuss.elastic.co/t/help-me-to-query-this-document/340110>\
**Category:** Elasticsearch\
**Created:** [August 4, 2023, 7:36am UTC](https://discuss.elastic.co/t/help-me-to-query-this-document/340110 "2023-08-04T07:36:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcin\_cron](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marcin_cron/32/130166_2.png) [@marcin\_cron](https://discuss.elastic.co/u/marcin_cron)\
**Post date:** [August 4, 2023, 7:36am UTC](https://discuss.elastic.co/t/help-me-to-query-this-document/340110/1 "2023-08-04T07:36:33Z")

</div>

This is my documents:

```auto
//document 1
{
    "place": "galaxy",
    "range": {
        "area": {
            "planet": "mars",
            "country": [

              -----------country 1------------------

                {
                    "name": "mars-country_1",
                    "use_by": "alien",
                    "region": [ 
   
             -------region 1--------

                        {
                            "name": "ABC",
                            "value": "ABC"
                        },

             -------region 2--------

                        {
                            "name": "DEF",
                            "value": "DEF"
                        }
                    ]
                },

              -----------country 2------------------

                {
                    "name": "mars-country_2",
                    "use_by": "alien_2",
                    "region": [
                        {
                            "name": "ABC",
                            "value": "ABC"
                        },
                        {
                            "name": "DEF",
                            "value": "DEF"
                        }
                    ]
                }
              -----------country 3------------------
              -----------country 4------------------
            ]
        }
    }
}
//document 2
//document 3

```

Now if I provide country name and region name: "mars-country\_1" and "ABC", the result will:

```auto
                {
                    "name": "mars-country_1",
                    "use_by": "alien",
                    "region": [
                        {
                            "name": "ABC",
                            "value": "ABC"
                        }
                    ]
                }

```

How can I do that, I do not know how to query in this case. Can anyone help me? Many thanks

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [August 4, 2023, 7:59am UTC](https://discuss.elastic.co/t/help-me-to-query-this-document/340110/2 "2023-08-04T07:59:18Z")

</div>

Welcome!

You can't really get that as a result as the full document you indexed will be returned.

But the question is: what are you searching for? A region?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [August 4, 2023, 8:49am UTC](https://discuss.elastic.co/t/help-me-to-query-this-document/340110/4 "2023-08-04T08:49:31Z")

</div>

If you are searching for region, you should index regions instead. So denormalize your data. It will make your life easier.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [August 4, 2023, 9:19am UTC](https://discuss.elastic.co/t/help-me-to-query-this-document/340110/6 "2023-08-04T09:19:02Z")

</div>

Have a look at this: [Retrieve inner hits | Elasticsearch Guide [8.9] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/inner-hits.html)

---

<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:** [September 1, 2023, 9:19am UTC](https://discuss.elastic.co/t/help-me-to-query-this-document/340110/7 "2023-09-01T09:19:08Z")

</div>

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