场景
按日期统计每日数据的条数,使用MongoTemplate实现按日期分组统计。
实现思路
先看看mongo命令怎么实现:
db.collection.aggregate([
{
$project: {date: {$dateToString: {format: "%Y-%m-%d", date: "$createTime"}}}
},
{$group: {_id: "$date", count: {$sum: 1}}},
{$project: {count: 1, _id: 0, date: "$_id"}},
{$sort: {"date": 1}}
])
对应的 java 实现:
Aggregation aggregation = Aggregation.newAggregation(
Aggregation.project("createTime").