# Nested Array Object

**URL:** <https://discuss.elastic.co/t/nested-array-object/145580>\
**Category:** Elasticsearch\
**Created:** [August 22, 2018, 3:20pm UTC](https://discuss.elastic.co/t/nested-array-object/145580 "2018-08-22T15:20:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![DjDigvijay](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@DjDigvijay](https://discuss.elastic.co/u/DjDigvijay)\
**Post date:** [August 22, 2018, 3:20pm UTC](https://discuss.elastic.co/t/nested-array-object/145580/1 "2018-08-22T15:20:17Z")

</div>

Having different members with nested mailOpens Array of Objects.

Have to solve this query:  
The list of users who have \>3 distinct mailOpens.mailingId records

{  
"\_index": "members",  
"\_type": "doc",  
"\_id": "1234567",  
"\_score": 2,  
"\_source": {  
"mailOpens": [  
{  
"created": "04/26/2017",  
"mailingId": 1  
},  
{  
"created": "04/26/2017",  
"mailingId": 1  
},  
{  
"created": "07/14/2017",  
"mailingId": 2  
},  
{  
"created": "07/14/2017",  
"mailingId": 2  
},  
{  
"created": "07/14/2017",  
"mailingId": 3  
},  
{  
"created": "07/14/2017",  
"mailingId": 3  
}  
,  
{  
"created": "07/14/2017",  
"mailingId": 4  
}  
,  
{  
"created": "07/14/2017",  
"mailingId": 4  
}  
]  
}  
}

Output should be like this for all members:

{  
"\_index": "members",  
"\_type": "doc",  
"\_id": "1234567",  
"\_score": 2,  
"\_source": {  
"mailOpens": [  
{  
"created": "04/26/2017",  
"mailingId": 1  
},

```
        {
          "created": "07/14/2017",
          "mailingId": 2
        },
        
      {
          "created": "07/14/2017",
          "mailingId": 3
        }
       ,
        {
          "created": "07/14/2017",
          "mailingId": 4
        }
      ]
    }
  }
```

---

<div class="post-metadata">

**Author:** ![DjDigvijay](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@DjDigvijay](https://discuss.elastic.co/u/DjDigvijay)\
**Post date:** [August 22, 2018, 4:31pm UTC](https://discuss.elastic.co/t/nested-array-object/145580/2 "2018-08-22T16:31:56Z")

</div>

Please help guys !!!!

---

<div class="post-metadata">

**Author:** ![DjDigvijay](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@DjDigvijay](https://discuss.elastic.co/u/DjDigvijay)\
**Post date:** [August 23, 2018, 1:42pm UTC](https://discuss.elastic.co/t/nested-array-object/145580/3 "2018-08-23T13:42:20Z")

</div>

Someone please take a look for this problem facing this from long time even do not get any possible solution for it ...plz help guys

---

<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 23, 2018, 2:01pm UTC](https://discuss.elastic.co/t/nested-array-object/145580/4 "2018-08-23T14:01:41Z")

</div>

Read [this](https://discuss.elastic.co/t/about-the-elasticsearch-category/21) and specifically the "Also be patient" part.

It's fine to answer on your own thread after 2 or 3 days (not including weekends) if you don't have an answer.

---

<div class="post-metadata">

**Author:** ![DjDigvijay](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@DjDigvijay](https://discuss.elastic.co/u/DjDigvijay)\
**Post date:** [September 5, 2018, 4:30pm UTC](https://discuss.elastic.co/t/nested-array-object/145580/5 "2018-09-05T16:30:29Z")

</div>

Now its almost around 1-2 week and still there is no reply ....no help then why this discuss elastic co stand for?

---

<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:** [October 3, 2018, 4:42pm UTC](https://discuss.elastic.co/t/nested-array-object/145580/6 "2018-10-03T16:42:39Z")

</div>

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