[{"_id":ObjectId("62684847e9594c65cbaa5d85"),"agentId":NumberInt(1),"agentName":"Digital Queen","policyList":[{"receivedDate":ISODate("2022-03-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(1),"policyStatusDate":ISODate("2022-02-20T04:46:15.000Z")},{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-02-19T05:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-01-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(3),"policyStatusDate":ISODate("2022-02-16T04:46:15.000Z")}]}]}]},{"_id":ObjectId("62684847e9594c65cbaa5d86"),"agentId":NumberInt(2),"agentName":"Iron Lady","policyList":[{"receivedDate":ISODate("2022-02-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-03-03T05:46:15.000Z")}]}]}]},{"_id":ObjectId("62684847e9594c65cbaa5d87"),"agentId":NumberInt(3),"agentName":"Proxy Agent","policyList":[{"receivedDate":ISODate("2022-04-10T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(1),"policiesArray":[{"policyDetailedCode":NumberInt(3),"policyStatusDate":ISODate("2022-04-09T05:46:15.000Z")}]}]}]}]

db.collection.aggregate({"$match":{"$expr":{"$reduce":{"input":"$policyList","initialValue":false,"in":{"$or":["$$value",{"$and":[{"$gte":["$$this.receivedDate",ISODate("2022-02-01")]},{"$lte":["$$this.receivedDate",ISODate("2022-03-01")]}]},{"$reduce":{"input":"$$this.policyStatusDetail","initialValue":false,"in":{"$or":["$$value",{"$reduce":{"input":"$$this.policiesArray","initialValue":false,"in":{"$or":["$$value",{"$and":[{"$gte":["$$this.policyStatusDate",ISODate("2022-02-01")]},{"$lte":["$$this.policyStatusDate",ISODate("2022-03-01")]}]}]}}}]}}}]}}}}})