Find all documents where the value of fieldA is the same as the value of fieldB

The document looks something like the following:

"username": "bobtest",
"displayName": "Bob Test",
"fullName": "Bob Test"

My example use case is find out how many customers use their full name as
their display name. In other words, how do I do an inner join I guess? I
want to find all documents where displayName == fullName. I don't see an
filters or aggs that accomplish this.



You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit
For more options, visit