Nested Array Object

Elastic Stack Elasticsearch
1

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
        }
      ]
    }
  }
2

Please help guys !!!!

3

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

4

Read this 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.

5

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

6

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