db.getCollection('transform_journal_set').aggregate([
{
"$group":{"_id":"$journal","count":{"$sum":1},"dups":{$addToSet:"$_id"}}
},
{
"$match":{"count":{"$gt":1}}
}
]
).forEach(function(doc){
doc.dups.pop();
db.transform_journal_set.remove({"_id":{$in:doc.dups}});
});
06-27
459
05-22