[ {
    "$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"
      }
    }
  } ]