Get all documents of having unique value with elasticsearch

for example:
i have many documents like this:
email status
1@123.com open
1@123.com click
2@123.com open
3@123.com open

i will query all documents with unique status value :"open", due to the record "1@123.com" contains "click" status, so "1@123.com" don't expect!

my expect response like this:
2@123.com open
3@123.com open

How can i do this job,tks..

link : https://stackoverflow.com/questions/49399197/get-all-documents-of-having-unique-value-with-elastic

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