Required Elastic Query with having Clause in Aggregation

Elastic Stack Elasticsearch
1

If Have One index having records with Properties Email and Event
We have different Events like Submitted, Delivered,Bounce etc.
I want to Get those record that available in Submitted only.
Means If any Email has to delivered or Bounce then it's not shows in the result.
Example:
Email Event
Sunny@x.com Delivered
Sunny@x.com Submitted
pp@x.com Submitted
If these are the record available in the index then It return on pp@x.com because it has only Submitted Record.

2

Hi @Sunny_Gupta

The Term Query can be used to filter docs with event type Submitted.

3

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