Database
[{"_id":{"$oid":"663a4dbb97674691089c835a"},"desc":{"name":"BLA BLA"},"pricing":[{"firstAddedDate":"05/30/2024","mrp":100,"price":100,"qty":1,"_id":{"$oid":"66578e181df0f2a544263b2b"}},{"firstAddedDate":"05/30/2024","mrp":100,"price":80,"qty":-1,"_id":{"$oid":"66580f3425b849794bb87bd7"}}]}]
Query
db.collection.find({_id:{"$oid":"663a4dbb97674691089c835a"},pricing:{$elemMatch:{mrp:100,price:100}}},{"pricing.$":1})