Required Not In Condition with in Same Index

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

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

Configuration:

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).