Database
[{from:ObjectId("6497cc25517300ca6a7e973f"),to:ObjectId("6497cda5517300ca6a7e9767"),status:"COMPLETED",},{from:ObjectId("6497cc25517300ca6a7e973f"),to:ObjectId("6497cda5517300ca6a7e9767"),status:"YOUR_TURN",},{from:ObjectId("6497cda5517300ca6a7e9767"),to:ObjectId("6497cc25517300ca6a7e973f"),status:"WAITING",}]
Query
db.collection.find({$expr:{$and:[{$or:[{$eq:["$from",ObjectId("6497cda5517300ca6a7e9767")]},{$eq:["$to",ObjectId("6497cda5517300ca6a7e9767")]}]},{$not:{$and:[{$eq:["$to",ObjectId("6497cda5517300ca6a7e9767")]},{$eq:["$status","YOUR_TURN"]}]}}]}})