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.

Possible?

Thanks!

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0fcbbdec-fb4b-4ce5-8ee7-293d487c0306%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.