Mongoose populate in array

Question

I try to play with populate but without success ... It's possible to do this?

I have 2 shema : - User

import mongoose, { Schema } from 'mongoose'

const userSchema = new Schema({
  email: { type: String, unique: true },
  password: String,
  passwordResetToken: String,
  passwordResetExpires: Date,

  products: [{
    productId: { type: Schema.Types.ObjectId, ref: 'Product' },
    dateAdd: { type: Date, default: Date.now }
  }]
}, { timestamps: true })

const User = mongoose.model('User', userSchema)

export default User

And Product :

import mongoose, { Schema } from 'mongoose'

const productSchema = new Schema({
  domain: String,
  originUrl: { type: String },
  price: Number,
  img: String,
  userFollow: [{ type: Schema.Types.ObjectId, ref: 'User' }]
})

const Product = mongoose.model('Product', productSchema)

export default Product

So I want to retrieve all the info for each of my prodcutId

I try this way (and many others without success):

User.findOne({ _id: userId }).populate({
      path: 'products.productId',
      populate: { path: 'products.productId', model: 'Products' }
}).exec(function (err, products) {
  if (err) {
    console.log('errors :' + err)
  }
  console.log('Product => ' + util.inspect(products))
})

Populate has no effect, same result with just the findOne()

You are not getting back products but one user with an array of products. And try removing model: 'Products' or doing model: 'Product'. — Mikey
– Mikey, Commented Jul 18, 2017 at 14:03

subaru710 · Accepted Answer · 2017-07-18 14:21:55Z

8

I think User.findOne({ _id: userId }).populate('products.productId') should work.

answered Jul 18, 2017 at 14:21

subaru710

5774 silver badges4 bronze badges

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

Comments

sohamdodia · Accepted Answer · 2017-07-18 14:17:57Z

1

Try using aggregate function of MongoDB and $lookup.

Users.aggregate([
    {
        "$match":
            {
                _id: user.id
            }
    },
    {
        "$lookup":
            {
                from: "Product",
                localField: "products",
                foreignField: "_id",
                as: "products"
            }
    }

])
.exec()
.then((result) => {
    //your result

})
.catch((err) => {
    // if any error
});

answered Jul 18, 2017 at 14:17

sohamdodia

3771 gold badge4 silver badges11 bronze badges

1 Comment

Mikey Over a year ago

I think it should be localField: "products.productId".

Collectives™ on Stack Overflow

Mongoose populate in array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related