我有 3 個模型User，Department， 和Ticket。
const TicketSchema = mongoose.Schema({
author: {
type: mongoose.Schema.Types.ObjectId,
ref: 'User'
}
const UserSchema = mongoose.Schema({
department: {
type: mongoose.Schema.Types.ObjectId,
ref: 'Department'
}
我正在嘗試從TicketModel 的某個部門查詢票證，我該怎么做？
例子： Ticket.find({ author.department: req.user.department }).populate('author')
uj5u.com熱心網友回復：
db.tickets.aggregate([
{
"$lookup": {
"from": "users",
"localField": "author",
"foreignField": "_id",
"as": "author"
}
},
{
"$unwind": "$author"
},
{
$match: {
"author.department": req.user.department
}
}
])
在這里測驗
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/339371.html