Query to Select Document based on only one object to be present under Node

Elastic Stack Elasticsearch
1

Hi,

We have data indexed as below

{
  "tags": {
    "firstlevel": {
      "events": [],
      "promotions": []
    }
  }
}

Data can be something like which has both events and promotions, just events or just promotions.

Requirement is like If i am only searching for events, I should match documents just having events as an array. Currently it is returning if events are matched but promotions are also present.

2

Hi @Harinder_Singh

From what I understand you only want doc with items in the events array, the promotions array must be empty.

In this case I would try to combine a must events equals xpto and an exists query in the promotions field inside a must_not. So the return would only be docs with events. Maybe this works on the data you cited so far.