如何在mongoose中填充嵌套对象?

Question

预订模式

const bookingSchema = new mongoose.Schema({
userId: {
type: mongoose.Schema.Types.ObjectId,
ref: "User",
required: true,
},
routeId:{
type: mongoose.Schema.Types.ObjectId,
ref: "Route",
required: true,
}
})

该表中routeId(路由模式)包含Bus表(被引用)。

const routeSchema = new mongoose.Schema({
location:{
type: mongoose.Schema.Types.ObjectId,
ref: 'Location',
required: true
},
duration: {
type: Number,
required: true
},
Bus:{
type: mongoose.Schema.Types.ObjectId,
ref:"Bus",
required: true
},
date: {
type:String,
required: true
},
},
{
timestamps: true,
});

最后是总线模型

const busSchema = new mongoose.Schema(
{
busNumber: {
type: String,
unique: true,
required: true,
},
seats: {
type: Number,
},
},
{
timestamps: true,
}
);

现在我只想显示车牌号，而不是整个车牌号。这是我得到的回应。https://i.stack.imgur.com/S1qyZ.png

这是我应用的查询。

router.get("/bus/myBooking/one/:id", auth, async (req, res) => {
const _id = req.params.id;
const myBooking = await Booking.findById({ _id })
.populate({path: 'routeId', populate: 'Bus'})
.select(["-_id","-userId","-createdAt","-updatedAt","-__v","-passengers._id","-departureDetails._id","-arrivalDetails._id"]);
try {
return !myBooking
? res.status(404).send("No booking found")
: res.status(200).send(myBooking);
} catch (e) {
res.status(500).send();
}
});

Answer 1

此方法适用于某些版本的mongoose，因此您可以试试:

await Booking.findById({ _id })
.populate({ 
path: 'routeId',
populate: {
path: 'Bus',
model: Bus,
select:"-_id busNumber"
} 
})