Required Not In Condition with in Same Index

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

Describe the issue:

f 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.
Email Event Delivered Submitted Submitted
If these are the record available in the index then It return on because it has only Submitted Record.


Relevant Logs or Screenshots:

Are Email and Event in different documents? If yes, you’ll likely want to use a Join field to link them. And then you can have a bool query that adds some properties of the “parent” - in your case Email - as well as from children - in your case you’d filter for submitted events.

If the properties are in the same document, you’d just filter for the Event properties you need (in your example Submitted).