Cannot populate nested array

Question

I know that this has been asked a million times, but it doesn't seem to be working for me. I cannot find a way to populate the references in an object when getting it from the database. No matter what I try it either returns an empty list or just the list of id's. What am I doing wrong here?

displayInventory: (req, res)=>{
    Merchant.find({otherId: merchantId})
        .populate({
            path: "ingredients", 
            populate: {
                path: "ingredient", 
                model: "Ingredient"
            }
        })
        .then((merchant)=>{
            console.log(merchant);
            if(merchant){
                return res.render("./inventory/inventory", {merchant: merchant});
            }else{
                return res.redirect("/merchant/new");
            }
        })
        .catch((err)=>{
            console.log(err);
            return res.render("error");
        });
}

const MerchantSchema = new mongoose.Schema({
    name: {
        type: String,
        required: true
    },
    otherId: {
        type: String,
        required: true
    },
    lastUpdatedTime: {
        type: Date,
        default: Date.now
    },
    ingredients: [{
        ingredient: {
            type: mongoose.Schema.Types.ObjectId,
            ref: "Ingredient"
        },
        quantity: {
            type: Number,
            min: [0, "Quantity cannot be less than 0"]
        }
    }],
    recipes: [{
        type: mongoose.Schema.Types.ObjectId,
        ref: "Recipe"
    }]
});

Cuong Le Ngoc · Accepted Answer · 2019-10-04 13:50:36Z

1

Refer to your schema, look like you just need to do:

Merchant.find({cloverId: merchantId}).populate("ingredients.ingredient")...

answered Oct 4, 2019 at 13:50

Cuong Le Ngoc

12k2 gold badges23 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Lee Morgan Over a year ago

When I do this it is just giving me the actual id, like this:

Lee Morgan Over a year ago

inventory: [ { _id: 5d97508e7929f31fb64a3196, quantity: 123 }, ...

Cuong Le Ngoc Over a year ago

What is inventory? I don't see it in your schema.

Lee Morgan Over a year ago

Inventory is the ejs page being rendered. However, I figured out my problem. Refactored and messed some things up in the database. Got it straightened out and this way of doing populate works perfectly. Thank you.

Lee Morgan · Accepted Answer · 2019-10-04 15:49:12Z

0

I will answer my own question in case others have a similar problem. My problem was that I renamed some variables but forgot to do it when saving data to the database. Stupid mistake, but just a reminder to be careful when refactoring. I used Coung Le Ngoc's answer, it works perfectly.

answered Oct 4, 2019 at 15:49

Lee Morgan

7462 gold badges9 silver badges32 bronze badges

Comments

Pushprajsinh Chudasama · Accepted Answer · 2019-10-05 04:36:05Z

0

You can try the below code.

Merchant.find({otherId: merchantId})
  .populate({ path: 'ingredients' })
  .exec(function(err, docs) {

    var options = {
      path: 'ingredients.components',
      model: 'Ingredient'
    };

    if (err) return res.json(500);
    Merchant.populate(docs, options, function (err, merchant) {
      res.json(merchant);
    });
  });

edited Oct 5, 2019 at 4:36

answered Oct 4, 2019 at 14:03

Pushprajsinh Chudasama

7,9994 gold badges23 silver badges48 bronze badges

1 Comment

Lee Morgan Over a year ago

When I add this I just get an error about Project not being defined. I don't really understand what this code is doing so I am not sure how to edit it for my needs...

Collectives™ on Stack Overflow

Cannot populate nested array

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related