分组获取数据:
db.express_info.group({ "key":{"express_code":true}, "initial":{"num":"0","mobile":"0"}, "reduce":function(doc,result){result.num++, result.mobile=doc.mobile}, "condition":{"mobile":"18663930231"},"finalize":function(result){result.is_push=result.num+1}})
分析:
key:分组使用的列
initial:设置初始返回元素
reduce:doc 是集合中的文档,result是initial的初始
condition:查询条件
finalize:在返回结果之前处理group的数据文档
返回数据:
[
{
"express_code" : "538419969049",
"num" : 17,
"mobile" : "18663930231",
"is_push" : 18
}
]
管道分组排序分页:
db.express_info.aggregate([{$match:{"mobile":"186