[{"_id":ObjectId("62684847e9594c65cbaa5d85"),"agentId":NumberInt(1),"agentName":"Yardi Gaondi","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-01-19T05:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-03-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(3),"policyStatusDate":ISODate("2022-01-16T04:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-02-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(1),"policyStatusDate":ISODate("2022-01-20T04:46:15.000Z")},{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-01-19T05:46:15.000Z")}]}]}]},{"_id":ObjectId("62684847e9594c65cbaa5d86"),"agentId":NumberInt(2),"agentName":"Michelle Hazandi","policyList":[{"receivedDate":ISODate("2022-04-10T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-04-09T05:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-03-10T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-03-09T05:46:15.000Z")}]}]}]},{"_id":ObjectId("626da96932cb6043086eae42"),"agentId":NumberInt(3),"agentName":"Barbie","policyList":[{"receivedDate":ISODate("2022-04-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(1),"policyStatusDate":ISODate("2022-05-20T04:46:15.000Z")},{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-01-19T05:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-02-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(3),"policyStatusDate":ISODate("2022-05-16T04:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-01-23T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(1),"policyStatusDate":ISODate("2022-03-20T04:46:15.000Z")},{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-01-19T05:46:15.000Z")}]}]}]},{"_id":ObjectId("626da96932cb6043086eae43"),"agentId":NumberInt(4),"agentName":"Mzandi","policyList":[{"receivedDate":ISODate("2022-05-10T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-02-09T05:46:15.000Z")}]}]},{"receivedDate":ISODate("2022-01-10T04:46:15.000Z"),"policyStatusDetail":[{"policyStsCode":NumberInt(7),"policiesArray":[{"policyDetailedCode":NumberInt(2),"policyStatusDate":ISODate("2022-02-09T05:46:15.000Z")}]}]}]}]

db.collection.aggregate({"$set":{"policyList":{"$filter":{"input":"$policyList","as":"policy","cond":{"$or":[{"$and":[{"$gte":["$$policy.receivedDate",ISODate("2022-02-01")]},{"$lte":["$$policy.receivedDate",ISODate("2022-03-01")]}]},{"$reduce":{"input":"$$policy.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")]}]}]}}}]}}}]}}}}},{"$match":{"$expr":{"$gt":[{"$size":"$policyList"},0]}}})