# Find duplicates

// Find duplicates
db.specialist.aggregate([
    {$group: {
        _id: {email: "$email"},
        uniqueIds: {$addToSet: "$_id"},
        count: {$sum: 1}
        }
    },
    {$match: {
        count: {"$gt": 1}
        }
    },
    {$sort: {
        count: -1
        }
    }
]).forEach(result => {
    result.uniqueIds.forEach(id => {
        printjson(id)
        var spec = db.specialist.findOne({_id: id});
        printjson(spec.email)
    })
})
Last Updated: 9/22/2020, 2:16:31 AM