我有一個任務架構 -
const taskSchema = new mongoose.Schema({
type: { type: String, default: '' },
completed_at: { type: Date, default: new Date() },
owner: { type: String, default: '' },
});
型別可以是 - A、B 和 C。
樣本資料 -
[{type: A, completed_at: '12-10-2021', owner: 'xyz'},
{type: A, completed_at: '12-10-2021', owner: 'abc'},
{type: C, completed_at: '12-10-2021', owner: 'xyz'},
{type: C, completed_at: '13-10-2021', owner: 'xyz'},
{type: B, completed_at: '13-10-2021', owner: 'xyz'}]
我想要這樣的東西 -
[{owner: 'xyz', completed_at: [ {completed_at: '12-10-2021', A: 1, B: 0, C: 1},
{completed_at: '13-10-2021', A: 0, B: 1, C: 1} ] },
{owner: 'abc', completed_at: {completed_at: '12-10-2021', A: 1, B: 0, C: 0}}]
我真的很困惑如何為此撰寫查詢。
uj5u.com熱心網友回復：
試試這個：
db.collection.aggregate([
{
$group: {
_id: {
owner: "$owner",
completed_at: "$completed_at"
},
type: { $push: "$type" }
}
},
{
$group: {
_id: "$_id.owner",
completed_at: { $push: "$$ROOT" }
}
},
{
$set: {
completed_at: {
$map: {
input: "$completed_at",
in: {
completed_at: "$$this._id.completed_at",
A: {
$size: {
$filter: {
input: "$$this.type",
as: "t",
cond: { $eq: [ "$$t", "A" ] }
}
}
},
B: {
$size: {
$filter: {
input: "$$this.type",
as: "t",
cond: { $eq: [ "$$t", "B" ] }
}
}
},
C: {
$size: {
$filter: {
input: "$$this.type",
as: "t",
cond: { $eq: [ "$$t", "C" ] }
}
}
}
}
}
}
}
}
])
通常我會做A，B并且是C動態的，但是我太懶了，喜歡上床睡覺。
蒙戈游樂場
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/326161.html