Database
[{"faculty":"20XX-XXXXX-XX-1","sections":[{"section":"XXXX 3-1","date":"04-11-2022","attendance":[{"number":"XXXXX","status":"Present"},{"number":"XXXXX","status":"Present"},{"number":"XXXXX","status":"Present"}]},{"section":"XXXX 3-2","date":"04-11-2022","attendance":[{"number":"XXXXX","status":"Present"},{"number":"XXXXX","status":"Present"},{"number":"XXXXX","status":"Present"}]}]}]
Query
db.collection.aggregate([{"$addFields":{"sections":{"$filter":{"input":"$sections","as":"s","cond":{$and:[{$eq:["$$s.section","XXXX 3-1"]},{$eq:["$$s.date","04-11-2022"]}]}}}}}])