目的:根据不同的部门查找出该部门下的今天产生的文档数目
db.getCollection('test').aggregate(
[
{ $match : { "adddate":{"$gte":ISODate("2018-01-02T00:00:00Z"),"$lte":ISODate("2018-01-03T00:00:00Z")},"is_history":0}},
{ $group: { _id: "$certawarddeptcode", count: { $sum: 1 } } }
])
$match是查询的情况,查询的过滤的条件
$group "_id" :“$certawarddeptcode”是分组的依据,
select certawarddeptcode,count(*) from test where adddate>="2018-01-02 00:00:00" and adddate<"2018-01-03 00:00:00" and is_history=0 group by certawarddeptcode;