如何在串列中填充索引，然后重命名其中一個索引？假設我有以下架構
const supplierSchema = new mongoose.Schema({
name: String,
address: String,
... (19 other fields)
supplier_id: mongoose.Schema.Types.ObjectId,
});
const itemsSchema = new mongoose.Schema({
name: String,
supplier_id: mongoose.Schema.Types.ObjectId,
item_id: mongoose.Schema.Types.ObjectId,
});
const receiptSchema = new mongoose.Schema({
items: [itemSchema]
receipt_id: mongoose.Schema.Types.ObjectId,
});
const Receipt = mongoose.model('Photo', photoSchema);
我的收據是這樣填充的
Receipt.findById(<insertID>) currently gives:
{
receipt_id: ObjectId("..."),
items: [
{
name: "...",
supplier_id: ObjectId("..."),
item_id: ObjectId("...")
},
{
name: "...",
supplier_id: ObjectId("..."),
item_id: ObjectId("...")
}
],
receipt_id: ObjectId("..."),
}
我想讓它supplier_id用nameand填充address。然后將其重命名supplier_id為supplier.
uj5u.com熱心網友回復：
將聚合與 $lookup 一起使用
Receipt.aggregate([
{$match : {_id : <insertID>} },
{
$lookup : {
from: 'supplier',
localField: 'items.supplier_id',
foreignField: '_id',
as: 'supplier'
}
},
{
$unwind : {
path : "supplier"
}
}
])
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/481737.html
標籤：javascript mongodb 猫鼬
上一篇：在mongoDb中查找具有2個欄位的所有檔案的最佳方法
下一篇：返回列表