[ {
"$match" : {
"startDate" : {
"$gte" : {
"$date" : "2024-09-10T07:14:37.02Z"
},
"$lte" : {
"$date" : "2024-10-10T07:14:37.02Z"
}
}
}
}, {
"$lookup" : {
"from" : "participant",
"localField" : "userId",
"foreignField" : "_id",
"as" : "participantData"
}
}, {
"$unwind" : "$participantData"
}, {
"$match" : {
"participantData.userStatus" : {
"$ne" : "TEST"
}
}
}, {
"$match" : {
"$and" : [ {
"participantData.email" : {
"$not" : {
"$regularExpression" : {
"pattern" : "deleted",
"options" : ""
}
}
}
}, {
"participantData.email" : {
"$not" : {
"$regularExpression" : {
"pattern" : "@smit\\.fit$",
"options" : ""
}
}
}
} ]
}
}, {
"$lookup" : {
"from" : "participantBaselineAndFollowupData",
"localField" : "userId",
"foreignField" : "participantId",
"as" : "baselineData"
}
}, {
"$unwind" : "$baselineData"
}, {
"$project" : {
"subscriptionId" : "$_id",
"programEndDate" : "$endDate",
"baselineId" : "$baselineData._id",
"userId" : 1,
"startDate" : 1,
"programStartDate" : "$baselineData.programStartDate",
"planCode1" : "$subscriptionPlan.programCode",
"journeyStatus" : "$journeyTrackerObject.status",
"planCode2" : "$baselineData.programCode",
"followUps" : "$baselineData.followUps"
}
}, {
"$match" : {
"$and" : [ {
"$expr" : {
"$and" : [ {
"$eq" : [ "$planCode1", "$planCode2" ]
}, {
"$eq" : [ "$startDate", "$programStartDate" ]
} ]
}
} ]
}
}, {
"$group" : {
"_id" : {
"userId" : "$userId",
"startDate" : "$startDate",
"planCode1" : "$planCode1"
},
"programEndDate" : {
"$last" : "$programEndDate"
},
"userId" : {
"$last" : "$userId"
},
"baselineId" : {
"$last" : "$baselineId"
},
"programStartDate" : {
"$last" : "$programStartDate"
},
"subscriptionId" : {
"$last" : "$subscriptionId"
},
"journeyStatus" : {
"$last" : "$journeyStatus"
},
"followUps" : {
"$last" : "$followUps"
}
}
} ]