Project 查詢到了 projectMember 的資料
const res = await ctx.model.Project
.aggregate([
{
$match: { title },
},
{
$lookup: {
from: 'projectMember',
localField: '_id',
foreignField: 'project_id',
as: 'members',
},
},
])
多了一個 members 欄位
[
{
"_id": "5eaab0716548c615306ed0fb",
"visible": "公開",
"type": "小說",
"title": "守燈人2",
"summary": "孤獨一直都在，從始至終。",
"user_id": "5eaa88c44fe6dc2ef013b8b8",
"create_at": "2020-04-30T11:03:13.861Z",
"update_at": "2020-04-30T11:03:13.862Z",
"__v": 0,
"members": [
{
"_id": "5eaab07144a25541579fa966",
"project_id": "5eaab0716548c615306ed0fb",
"user_id": "5eaa88c44fe6dc2ef013b8b8",
"__v": 0,
"type": "admin"
}
]
}
]
現在，我想要，繼續多表查詢 members 里所有檔案的 user_id （關聯 User 表），請問怎么實作？
uj5u.com熱心網友回復：
繼續對members lookup 的foreignField 要改成members.user_id轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/15032.html
標籤：MongoDB
上一篇：mysql資料庫日志求助