Is there a way to compare the values of two fields to see if they are the same?
Let's say we have an index with these fields: ID: 2 childID: 7 parentID: 0 -------------------- ID: 3 childID: 6 parentID: 5 -------------------- ID: 4 childID: 2 parentID: 2 -------------------- Based on these three documents, I want the query to return the third document where childID=parentID.
