1

I have a user schema with the sub-schema called project and inside the project I have another schema called boq. How can I populate boqs and projects all in one page without using findById. I can populate projects by User.findById(req.user.id...etc but for projects, I cant use findById. anyway to populate boqs inside projects?

User schema:

var UserSchema = new Schema({
            company: String,
            projects: [
                {
                    type: mongoose.Schema.Types.ObjectId,
                    ref: "Project",
                }
            ],

});

Below is the project schema:

var projectSchema = new Schema({
        pname: String,
        boqs: [
            {
                type: mongoose.Schema.Types.ObjectId,
                ref: "Boq",
            }
        ],

});

And boq schema:

var boqSchema = new Schema({

        boqHeadIn: String,
        boqHead: String,
        boqIn: String,
        boqDesc: String,
        boqUnit: String,
        boqQty: Number,
        boqRate: Number,
        boqPrice: Number,

});
Sam
  • 197
  • 1
  • 11

0 Answers0