我遇到了像這樣獲得所需輸出的問題
[
{
"status": "ONBOARD"
"count": 1
},
{
"status": "PENDING"
"count": 1
},
]
我是這樣的：
[
{
"_id": {
"status": "ONBOARD"
},
"count": 1
},
{
"_id": {
"status": "CLIENT_ROUND"
},
"count": 2
},
{
"_id": {
"status": "SCREENED"
},
"count": 1
}
]
這是我的匯總：
const result = await Lead.aggregate([
{
$group: {
_id: { status: '$status' },
count: { $sum: 1 }
}
$project: { _id: 0, status: 1, count: 1 }
}
幫助我獲得輸出 我是新人 我已經應用了 $project 但給了我錯誤
uj5u.com熱心網友回復：
你快到了。隨著status: "$_id.status"在投影階段。
db.collection.aggregate([
{
$group: {
_id: {
status: "$status"
},
count: {
$sum: 1
}
}
},
{
$project: {
_id: 0,
status: "$_id.status",
count: 1
}
}
])
示例 Mongo Playground
或者只是$group與_id: "$status".
db.collection.aggregate([
{
$group: {
_id: "$status",
count: {
$sum: 1
}
}
},
{
$project: {
_id: 0,
status: "$_id",
count: 1
}
}
])
示例 Mongo Playground 2
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/389727.html