Database
[{"_id":ObjectId("5ea32d11f213c27c35395fd3"),"name":"Test","state":"OH","code":"CDM"},{"_id":ObjectId("5ea32d29f213c27c35395fe0"),"name":"Test1","state":"ALL","code":"CDM"},{"_id":ObjectId("5ea32d38f213c27c35395fe7"),"name":"Test2","state":"OH","code":"ALL"},{"_id":ObjectId("5ea32d46f213c27c35395feb"),"name":"Test3","state":"ALL","code":"ALL"},{"_id":ObjectId("5ea32d38f213c27c35395f20"),"name":"Test20","state":"CA","code":"ALL"},{"_id":ObjectId("5ea32d38f213c27c35395f10"),"name":"Test10","state":"CA","code":"CDM"}]
Query
db.collection.find({$or:[{state:"CA",code:"CDM"},{state:"ALL",code:"CDM"},{state:"ALL",code:"ALL"},{state:"CA",code:"ALL"}]})