我有两个集合,例如清单和任务。两个模式如下所示
清单架构如下所示
{
"_id": "5b7d0f77e231b6b530b0ee5a",
"audit_checklist_type": "Weekly"
}, {
"_id": "5b7d3f33e7a57f38084efb09",
"audit_checklist_type": "Daily"
}
任务架构如下所示
{
"_id": "5b7d65daf74be318e8378cf9",
"checklist_id": "5b7d3f33e7a57f38084efb09"
}, {
"_id": "5b7d662df74be318e8378cfb",
"checklist_id": "5b7d3f33e7a57f38084efb09"
}
我的查询是
AuditChecklist.aggregate([
{
$match: {
$and: [
audit_checklist_type: "Daily"
]
},
},
{
$lookup: {
from: 'AuditTask',
localField: '_id',
foreignField: 'checklist_id',
as: 'TaskData',
},
},
]).exec()
我试图得到像这样的输出
{
"_id": "5b7d3f33e7a57f38084efb09",
"TaskData ": [{
"_id": "5b7d65daf74be318e8378cf9",
"checklist_id": "5b7d3f33e7a57f38084efb09"
},
{
"_id": "5b7d662df74be318e8378cfb",
"checklist_id": "5b7d3f33e7a57f38084efb09"
}
]
}
但对我来说,结果 TaskData 输出是空的。
任何帮助是极大的赞赏。提前致谢!