[ { $group: { _id: "$participantId", documents: { $push: "$$ROOT" }, count: { $sum: 1 } } }, { $match: { count: { $gt: 1 } } }, { $unwind: "$documents" }, { $match: { "documents.programCode": { $ne: "" } } }, { $group: { _id: { participantId: "$_id", programCode: "$documents.programCode", programStartDate: "$documents.programStartDate" }, documents: { $push: "$documents" }, count: { $sum: 1 } } }, { $match: { count: { $gt: 1 } } }, { $project: { _id: 0, participantId: "$_id.participantId", programCode: "$_id.programCode", programStartDate: "$_id.programStartDate" } }, { $lookup: { "from": "participant", "localField": "participantId", "foreignField": "_id", "as": "temp" } }, { $match: { "temp.userStatus": { $ne: "TEST" } } }, { $project: { "id":{ $arrayElemAt: ["$temp._id", 0] } "email": { $arrayElemAt: ["$temp.email", 0] } } } ]
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter