mongodb利用aggregate聚合group by多个字段

转载：https://blog.csdn.net/s630405377/article/details/78478981

var result = db.orderMain.aggregate([
{$match:{
partnerId:{$eq:"aaa"}
}},
{$group:{
_id:{
partnerId:"$partnerId",
clientCode:"$shipper.clientCode",
clientName:"$shipper.clientName",
merchantName:"$shipper.contacts"}
}
}
])

//边读边取插入
while(result.hasNext()){
var next = result.next();
    db.新建表.insert({
    _id:new ObjectId(),
            partnerId: next._id.partnerId,
        clientCode: next._id.clientCode,
        clientName: next._id.clientName,
        merchantId: new ObjectId(),
        merchantName: next._id.merchantName
    })
}

 

$match先根据条件匹配数据

$group指定了多个字段进行筛选