[{"_id":{"$oid":"616309f71b021c754992bfca"},"correlatedNodes":[{"type":"IS_ULTIMATELY_CONSOLIDATED_BY","nodes":["I07WOS4YJ0N7YRFE7309"]},{"type":"test","nodes":["89450012XZ2GPWGIGH37"]}],"fromTaskId":20,"nodeName":"5493000U0YGG4VEQOX65"},{"_id":{"$oid":"616309f71b021c754992bfcb"},"correlatedNodes":[{"type":"IS_DIRECTLY_CONSOLIDATED_BY","nodes":["529900P6OUCFPVWCFE19","8945007IZBKFQUQLIP85"]},{"type":"IS_ULTIMATELY_CONSOLIDATED_BY","nodes":["529900P6OUCFPVWCFE19"]},{"type":"test","nodes":["5493000U0YGG4VEQOX65"]}],"fromTaskId":20,"nodeName":"89450012XZ2GPWGIGH37"},{"_id":{"$oid":"616309f71b021c754992bfcc"},"correlatedNodes":[{"type":"IS_ULTIMATELY_CONSOLIDATED_BY","nodes":["815600C9588783AB0210"]},{"type":"IS_DIRECTLY_CONSOLIDATED_BY","nodes":["815600C9588783AB0210"]}],"fromTaskId":20,"nodeName":"815600228127946DFF05"},{"_id":{"$oid":"616309f71b021c754992bfcd"},"correlatedNodes":[{"type":"IS_ULTIMATELY_CONSOLIDATED_BY","nodes":["549300LI58A0MHGHTZ98"]}],"fromTaskId":20,"nodeName":"549300NV4OCF16TAS048"}]

db.collection.aggregate([{"$unwind":"$correlatedNodes"},{"$unwind":"$correlatedNodes.nodes"},{"$graphLookup":{"from":"collection","startWith":"$correlatedNodes.nodes","connectFromField":"correlatedNodes.nodes","connectToField":"nodeName","as":"nodeChain","depthField":"depth","restrictSearchWithMatch":{"nodeName":{$ne:"$nodeName"}}}},{/** remove empty nodeChain first*/"$unwind":"$nodeChain"},{"$addFields":{isCircular:{"$reduce":{"input":"$nodeChain.correlatedNodes","initialValue":false,"in":{$or:["$$value",{"$reduce":{"input":"$$this.nodes","initialValue":false,"in":{$or:["$$value",{$eq:["$$this","$nodeName"]}]}}}]}}}}},{"$match":{isCircular:true}}])