db={"Rating":[{"_id":ObjectId("6255818aaaaa7f47c79eba01"),"_class":"rating","ratingid":"b6885038-17ef-437c-b9c8-be7336a09744","value":5,"components":[{"resultid":"69053352-d933-46a0-a20c-3863e01b87d6"},{"resultid":"2285e41f-ebe4-4372-8cf8-64dfe91a9733"}]},{"_id":ObjectId("6255818aaaaa7f47c79eba03"),"_class":"test","ratingid":"this should not be returned","value":-1,"components":[{"resultid":"2285e41f-ebe4-4372-8cf8-64dfe91a9733"},{"resultid":"2285e41f-ebe4-4372-8cf8-64dfe91a9733"}]},{"_id":ObjectId("6255818aaaaa7f47c79eba02"),"_class":"test","ratingid":"this should not be returned","value":-1,"components":[{"resultid":"2285e41f-ebe4-4372-8cf8-64dfe91a9733"}]}],"Result":[{"_id":ObjectId("62558188aaaa7f47c79eb9ff"),"_class":"normal_results","resultid":"2285e41f-ebe4-4372-8cf8-64dfe91a9733","totalTime":10.0,"lastModified":NumberLong("1649770887268"),"creationDate":NumberLong("1649770887268"),}]}

db.Rating.aggregate([{"$lookup":{"from":"Result","localField":"components.resultid","foreignField":"resultid","as":"resultLookup"}},{"$addFields":{"dedupeComponents":{"$reduce":{"input":"$components","initialValue":[],"in":{"$cond":{"if":{"$in":["$$this.resultid","$$value"]},"then":"$$value","else":{"$concatArrays":["$$value",["$$this.resultid"]]}}}}},"resultLookup":{"$reduce":{"input":"$resultLookup","initialValue":[],"in":{"$cond":{"if":{"$in":["$$this.resultid","$$value"]},"then":"$$value","else":{"$concatArrays":["$$value",["$$this.resultid"]]}}}}}}},{$addFields:{matched:{$eq:[{$size:"$dedupeComponents"},{$size:"$resultLookup"}]}}},{"$match":{matched:false}},{"$project":{/** cosmetics*/matched:false,dedupeComponents:false,resultLookup:false}}])