Database

[{"_id":ObjectId("6115b2cc1681596a10072f97"),"vendorStatus":"Active","name":"harshit singh bhutani","email":"sharsh2106@gmail.com","vId":12121,"contact":121212,"cities":"dell","isMidnight":"NA","location":[{"delivery":1266,"dc":"High","midnight":"Active","isLive":"Active","_id":ObjectId("612433c27292d11154bc4d4d"),"pincode":123100,"city":"dek"},{"delivery":23,"dc":"High","midnight":"Active","isLive":"NA","_id":ObjectId("612441473cb5766a2457d6db"),"pincode":1212,"city":"dd"}],"createdAt":ISODate("2021-08-12T23:46:20.407Z"),"updatedAt":ISODate("2021-09-03T10:51:34.756Z"),"__v":73}]

Query

db.collection.aggregate([{"$match":{"vendorStatus":"Active"}},{"$unwind":"$location"},{"$match":{"location.pincode":123100,"location.isLive":"Active"}},{"$project":{"delivery":"$location.delivery","dc":"$location.dc","midnight":"$location.midnight","isLive":"$location.isLive","_id":"$location._id","pincode":"$location.pincode","city":"$location.city"}}])

Result