db={"members":[{recordNo:101,/**member id*/registerdDate:ISODate("2024-01-01T00:00:00.000Z"),personName:"James"},{recordNo:102,registerdDate:ISODate("2024-02-03T00:00:00.000Z"),personName:"Smith"},{recordNo:103,registerdDate:ISODate("2024-08-01T00:00:00.000Z"),personName:"Alex"}],"memberActivities":[{recordNo:101,/**Reference to members.recordNo in above collection*/activityDate:"05-Jan-2024",activity:[/**Array*/{Comments:"Played Chess"},{Comments:"Played Hockey"},{Comments:"Played Cricket"}]},{recordNo:101,activityDate:"06-Jan-2024",activity:[/**Array*/{Comments:"Outing with friends"}]},{recordNo:102,activityDate:"08-Feb-2024",activity:[/**Array*/{Comments:"Played Basketball"}]},{recordNo:103,activityDate:"20-Sep-2023",activity:[/**Array*/{Comments:"Played Cricket"}]}]}

db.members.aggregate([{"$match":{registerdDate:{$gte:ISODate("2024-01-01T00:00:00.000Z"),$lt:ISODate("2024-03-01T00:00:00.000Z")}}},{"$lookup":{"from":"memberActivities","localField":"recordNo","foreignField":"recordNo","as":"memberActivities"}},{"$match":{"$nor":[{"memberActivities.activity.Comments":"Played Cricket"}]}}])