我是貓鼬的新手，遇到了一些問題。我有 2 個實體：Patient 和 Appointment。他們看著像是：
const AppointmentSchema = new mongoose.Schema({
patient: { type: Schema.Types.ObjectId, ref: 'Patient' },
dentNumber: Number,
diagnosis: String,
price: Number,
date: String,
time: String
}, {
timestamps: true
});
const PatientSchema = new mongoose.Schema({
fullname: String,
phone: String,
}, {
timestamps: true
});
PatientSchema.virtual('Appointments', {
ref: 'Appointment',
localField: '_id',
foreignField: 'patient',
justOne: false
})
約會資料如下所示：
{
"success": true,
"data": [
{
"_id": "61cb1cad610963c75f7e41a2",
"patient": {
"_id": "61c045bcb0c7e68c96e6ba0e",
"fullname": "test 126",
"phone": " 7 123 54 55",
"createdAt": "2021-12-20T08:58:36.776Z",
"updatedAt": "2021-12-20T08:58:36.776Z",
"__v": 0
},
"dentNumber": 33,
"diagnosis": "String3",
"price": 500,
"date": "18-10-2021",
"time": "15:50",
"createdAt": "2021-12-28T14:18:21.537Z",
"updatedAt": "2021-12-28T14:24:29.576Z",
"__v": 0
},
{
"_id": "61cc26bd7d1e9476e52c4b35",
"patient": {
"_id": "61c045bcb0c7e68c96e6ba0e",
"fullname": "test 126",
"phone": " 7 123 54 55",
"createdAt": "2021-12-20T08:58:36.776Z",
"updatedAt": "2021-12-20T08:58:36.776Z",
"__v": 0
},
"dentNumber": 4,
"diagnosis": "String3",
"price": 1600,
"date": "17-10-2021",
"time": "16:50",
"createdAt": "2021-12-29T09:13:33.575Z",
"updatedAt": "2021-12-29T09:13:33.575Z",
"__v": 0
},
{
"_id": "61cc3663970d00f9129d0456",
"patient": {
"_id": "61c045bcb0c7e68c96e6ba0e",
"fullname": "test 126",
"phone": " 7 123 54 55",
"createdAt": "2021-12-20T08:58:36.776Z",
"updatedAt": "2021-12-20T08:58:36.776Z",
"__v": 0
},
"dentNumber": 5,
"diagnosis": "String4",
"price": 1700,
"date": "18-10-2021",
"time": "17:50",
"createdAt": "2021-12-29T10:20:19.257Z",
"updatedAt": "2021-12-29T10:20:19.257Z",
"__v": 0
},
]
}
我需要以這種方式按日期對約會進行排序：
await Appointment
.aggregate([
{ $group: {
_id: "$date",
data: { $push: {
id: "$_id",
patientId: "$patient",
//patient: { patient: await Patient.findById(mongoose.Types.ObjectId.fromString("$patient")) },
dentNumber: "$dentNumber",
diagnosis: "$diagnosis",
price: "$price",
date: "$date",
time: "$time"
} }
} },
{ $sort: { _id: 1 } },
])
在此之后，我得到了正確形式的答案：
{
"success": true,
"data": [
{
"_id": "17-10-2021",
"data": [
{
"id": "61cb1cad610963c75f7e41a2",
"patientId": "61c045bcb0c7e68c96e6ba0e",
"dentNumber": 33,
"diagnosis": "String3",
"price": 500,
"date": "17-10-2021",
"time": "15:50"
},
{
"id": "61d1651b25ab055c5cc913ac",
"patientId": "61be3e6b51b968aa92d5e248",
"dentNumber": 5,
"diagnosis": "String4",
"price": 1750,
"date": "17-10-2021",
"time": "19:35"
}
]
},
{
"_id": "18-10-2021",
"data": [
{
"id": "61cc26bd7d1e9476e52c4b35",
"patientId": "61c045bcb0c7e68c96e6ba0e",
"dentNumber": 4,
"diagnosis": "String3",
"price": 1600,
"date": "18-10-2021",
"time": "16:50"
},
]
},
但是"patientId"我需要以某種方式獲得一個完整的物件 Patient，而不是財產。要使資料看起來像這樣：
{
"success": true,
"data": [
{
"_id": "17-10-2021",
"data": [
{
"id": "61cb1cad610963c75f7e41a2",
"dentNumber": 33,
"diagnosis": "String3",
"price": 500,
"date": "17-10-2021",
"time": "15:50",
"patient": {
"_id": "61c045bcb0c7e68c96e6ba0e",
"fullname": "test 126",
"phone": " 7 123 54 55",
"createdAt": "2021-12-20T08:58:36.776Z",
"updatedAt": "2021-12-20T08:58:36.776Z",
"__v": 0
}
},
{
"id": "61d1651b25ab055c5cc913ac",
"dentNumber": 5,
"diagnosis": "String4",
"price": 1750,
"date": "17-10-2021",
"time": "19:35",
"patient": {
"_id": "61be3e6b51b968aa92d5e248",
"fullname": "test 421",
"phone": " 7 123-11-22",
"createdAt": "2021-12-18T20:02:51.177Z",
"updatedAt": "2021-12-28T14:41:45.948Z",
"__v": 0
}
}
]
},
{
"_id": "18-10-2021",
"data": [
{
"id": "61cc26bd7d1e9476e52c4b35",
"dentNumber": 4,
"diagnosis": "String3",
"price": 1600,
"date": "18-10-2021",
"time": "16:50",
"patient": {
"_id": "61c045bcb0c7e68c96e6ba0e",
"fullname": "test 126",
"phone": " 7 123 54 55",
"createdAt": "2021-12-20T08:58:36.776Z",
"updatedAt": "2021-12-20T08:58:36.776Z",
"__v": 0
}
}
]
},
]
}
uj5u.com熱心網友回復：
您不能通過在任何查詢中傳遞內部欄位來執行另一個查詢，您需要在組之前進行查找操作，
$lookup與患者收集，patient作為 localField 傳遞并_id作為 foreignField傳遞$group階段，用于$first從患者的查找結果中獲取第一個元素
await Appointment.aggregate([
{
$lookup: {
from: "patient",
localField: "patient", // change to your exact collection name
foreignField: "_id",
as: "patient"
}
},
{
$group: {
_id: "$date",
data: {
$push: {
id: "$_id",
patientId: { $first: "$patient._id" },
patient: { $first: "$patient" },
dentNumber: "$dentNumber",
diagnosis: "$diagnosis",
price: "$price",
date: "$date",
time: "$time"
}
}
}
},
{ $sort: { _id: 1 } }
])
操場
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/401462.html
上一篇：如何使用MongoDB上的嵌套資料進行雙$lookup聚合？
下一篇：Mongoose：填充2級子物件