Database
- bson
- mgodatagen
[{"_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":{$filter:{input:"$pricing",cond:{$and:[{$eq:["$$this.mrp",100]},{$eq:["$$this.price",100]}]}}}})