Database
[{_id:12345,createdDate:"2020-07-10",cars:[{type:"Sedan",engine:[{type:"Petrol",power:150,brake:{type:"Disc",hasABS:false}},{type:"Petrol",power:190,brake:{type:"Drum",hasABS:false}},{type:"Diesel",power:160,brake:{type:"Disc",hasABS:true}}]},{type:"SUV",engine:[{type:"Petrol",power:150,brake:{type:"Disc",hasABS:false}},{type:"Petrol",power:190,brake:{type:"Drum",hasABS:false}},{type:"Diesel",power:160,brake:{type:"Disc",hasABS:true}}]}]}]
Query
db.collection.aggregate([{$match:{createdDate:{$gte:"2020-07-01",$lte:"2020-07-31"}}},{"$unwind":"$cars"},{"$unwind":"$cars.engine"},{"$match":{"cars.engine.brake.hasABS":true}}])