db={"rooms":[{"_id":"65ef799f331ab6aef4fae5ba","number":"1","length":"10","width":"12"},{"_id":"65ef79a0331ab6aef4fae5be","number":"2","length":"10","width":"12"}],"kennels":[{"_id":"65ef79a2331ab6aef4fae5d4","REF_RoomID":"65ef799f331ab6aef4fae5ba","identifier":"1.1.6x10","active":true,"partition":"1","length":10,"width":6},{"_id":"65ef79a2331ab6aef4fae5d5","REF_RoomID":"65ef799f331ab6aef4fae5ba","identifier":"1.2.6x10","active":true,"partition":"2","length":10,"width":6},{"_id":"65ef79a3331ab6aef4fae5e5","REF_RoomID":"65ef79a0331ab6aef4fae5be","identifier":"2.1.4x10","active":true,"partition":"1","length":10,"width":4},{"_id":"65ef79a3331ab6aef4fae5e6","REF_RoomID":"65ef79a0331ab6aef4fae5be","identifier":"2.2.4x10","active":true,"partition":"2","length":10,"width":4},{"_id":"65ef79a3331ab6aef4fae5e7","REF_RoomID":"65ef79a0331ab6aef4fae5be","identifier":"2.3.4x10","active":true,"partition":"3","length":10,"width":4}],"bookings":[{"_id":"65ef88f444e7d6607498ac2e","REF_KennelID":"65ef79a2331ab6aef4fae5d4","year":2024,"dayOfYear":100,"duration":6},{"_id":"65f0ca69f2667460e600a46a","REF_KennelID":"65ef79a2331ab6aef4fae5d4","year":2024,"dayOfYear":107,"duration":1}]}

db.kennels.aggregate([{$lookup:{from:"rooms",localField:"REF_RoomID",foreignField:"_id",as:"room"}},{$unwind:{path:"$room",preserveNullAndEmptyArrays:false}},{$lookup:{from:"bookings",localField:"_id",foreignField:"REF_KennelID",as:"bookings"}},{$match:{$and:[{active:true},{"room.number":{$in:["1","2"]}},/*** this is my problem area*{ 'bookings.year': { $eq: 2024 } },*{ 'bookings.dayOfYear': { $eq: 100 } }*/]}},{$project:{__v:0,REF_RoomID:0,room:0,"bookings.REF_KennelID":0,"bookings.__v":0}}])