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({$and:[{$or:[{from:ObjectId("6497cda5517300ca6a7e9767")},{to:ObjectId("6497cda5517300ca6a7e9767")}]},{$nor:[{$and:[{to:ObjectId("6497cda5517300ca6a7e9767")},{status:"YOUR_TURN"}]}]}]})