[{_id:ObjectId("56f277b1279871c20b8b4566"),product_name:"sample product 1",product_items:[{product_price:50.99,product_item_no:"123456789",product_images:["default.png"]},{product_price:11.99,product_item_no:"683456789",product_images:["default2.png"]}],product_status_is_active:true,},{_id:ObjectId("56f277b1279871c20b8b4567"),product_name:"sample product 2",product_items:[{product_price:12.99,product_item_no:"45678923",product_images:["default2.png"]},{product_price:66.99,product_item_no:"683456789",product_images:["default4.png"]}],product_status_is_active:true,}]

db.collection.aggregate([{$match:{"product_status_is_active":true}},{$addFields:{product_items:{$filter:{input:"$product_items",cond:{$and:[{$gte:["$$this.product_price",60]},{$lte:["$$this.product_price",100]}]}}}}},{$match:{product_items:{$ne:[]}}}])