</pre><pre name="code" class="javascript">db.collections.aggregate({
$match: {
shopId: '57297eb73876d9e776d8875d'
}
},
{
$group: {
_id: {
month: {
$cond: [
{
$ifNull: [
'$reservationDate',
0
]
},
{
$month: '$reservationDate'
},
0
]
},
day: {
$cond: [
{
$ifNull: [
'$reservationDate',
0
]
},
{
$dayOfMonth: '$reservationDate'
},
0
]
},
year: {
$cond: [
{
$ifNull: [
'$reservationDate',
0
]
},
{
$year: '$reservationDate'
},
0
]
}
},
createdAt: {
$last: '$reservationDate'
},
count: {
$sum: 1
}
}
},
{
$project: {
_id: 0,
createdAt: 1,
count: 1
}
},
{
$sort: {
reservationDate: 1
}
}
])
mongodb判空做统计的例子
最新推荐文章于 2022-10-29 15:32:51 发布