# Quring a nested array object

**URL:** <https://discuss.elastic.co/t/quring-a-nested-array-object/31378>\
**Category:** Elasticsearch\
**Created:** [September 30, 2015, 5:08am UTC](https://discuss.elastic.co/t/quring-a-nested-array-object/31378 "2015-09-30T05:08:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nitish\_MIshra](https://avatars.discourse-cdn.com/v4/letter/n/e0b2c6/32.png) [@Nitish\_MIshra](https://discuss.elastic.co/u/Nitish_MIshra)\
**Post date:** [September 30, 2015, 5:08am UTC](https://discuss.elastic.co/t/quring-a-nested-array-object/31378/1 "2015-09-30T05:08:34Z")

</div>

Hi All,

I have the fallowing object stored in ES.

```
{
  "objectId": "10",
  "userPermissions1": [
    {
      "id": "1",
      "prm": [
        "A",
        "B"
      ]
    },
    {
      "id": "2",
      "prm": [
        "F",
        "G",
        "H"
      ]
    }
  ]
}

```

Now I want to query the userPermissions1.prm where objectId = 10 and userPermissions1.id = 2

Please help me..

Thanks in advance 😄

---

<div class="post-metadata">

**Author:** ![Nitish\_MIshra](https://avatars.discourse-cdn.com/v4/letter/n/e0b2c6/32.png) [@Nitish\_MIshra](https://discuss.elastic.co/u/Nitish_MIshra)\
**Post date:** [September 30, 2015, 6:51am UTC](https://discuss.elastic.co/t/quring-a-nested-array-object/31378/2 "2015-09-30T06:51:23Z")

</div>

Please help guys !!!! ☹

---

<div class="post-metadata">

**Author:** ![davidbkemp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/davidbkemp/32/594_2.png) [@davidbkemp](https://discuss.elastic.co/u/davidbkemp)\
**Post date:** [October 1, 2015, 8:02am UTC](https://discuss.elastic.co/t/quring-a-nested-array-object/31378/3 "2015-10-01T08:02:59Z")

</div>

What have you tried so far? A bool/must query could be used to find the document. But if you want the specific embedded object, then you will need to use a parent/child mapping  
[https://www.elastic.co/guide/en/elasticsearch/guide/current/parent-child-mapping.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/parent-child-mapping.html)

---

<div class="post-metadata">

**Author:** ![davidbkemp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/davidbkemp/32/594_2.png) [@davidbkemp](https://discuss.elastic.co/u/davidbkemp)\
**Post date:** [October 1, 2015, 8:14am UTC](https://discuss.elastic.co/t/quring-a-nested-array-object/31378/4 "2015-10-01T08:14:06Z")

</div>

Alternatively, you may find using a "nested" mapping suits your needs:  
[https://www.elastic.co/guide/en/elasticsearch/guide/current/nested-objects.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/nested-objects.html)

If you need to know which of the nested objects matched, then you will need to use the (still experimental?) inner-hits directive:  
[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-inner-hits.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-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:** [July 5, 2017, 11:47pm UTC](https://discuss.elastic.co/t/quring-a-nested-array-object/31378/5 "2017-07-05T23:47:16Z")

</div>