转载: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指定了多个字段进行筛选