Shulou(Shulou.com)06/01 Report--

The original table records:

You need to delete the same entry as related_type=1 and action_type=3 and related_id. Only one is left to weigh.

Db.user_action_log.aggregate ([

{$match: {related_type:1,action_type:3}}, (query criteria)

{

$group: {_ id: {related_id:'$related_id'}, count: {$sum: 1}, dups: {$addToSet:'$_ id'}} (according to related_id grouping, $group will only return the fields that participate in the grouping, and use $addToSet to add the _ id field to the returned result array)

}, {$match: {count: {$gt: 1}} (match data with a quantity greater than 1)}

]) .forEach (function (doc) {(delete data based on _ id using forEach loop)

Doc.dups.shift ()

Db.user_action_log.remove ({_ id: {$in: doc.dups}})

})

Deleted data:

Db.user_action_log.aggregate ([

{$match: {related_type:1,action_type:3}}

{

$group: {_ id: {related_id:'$related_id'}, count: {$sum: 1}, dups: {$addToSet:'$_ id'}}

}, {$match: {count: {$gt: 1}

]) .forEach (function (doc) {

Doc.dups.shift ()

Db.user_action_log.remove ({_ id: {$in: doc.dups}})

})

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.