How to use populate method with MongoDB in Node.js?

Question

I have the following code:

const Order = require('../../models/order');
const Product = require('../../models/product');

Order.find({}, '_id product quantity', function(err, result) {
  if (result) {
    const response = {
      count: result.length,
      createdOrder: result.map(function(order) {
        return {
          _id: order._id,
          productId: order.product,
          quantity: order.quantity,
          request: {
            type: 'GET',
            url: 'http://localhost:3000/orders/' + order._id
          }
        }
      })
    };
    res.status(200).json(response);
  } else if (err) {
    console.log(err);
    res.status(404).json({
      error: err
    });
  }
});

How to use populate method to give more information about the product in the above syntax?

dotnetdev4president · Accepted Answer · 2018-07-05 08:39:35Z

1

In your Order Schema you should set up a ref:

const mongoose = require('mongoose');

const orderSchema = mongoose.Schema({
  // ...,
  product: { type: mongoose.Schema.Types.ObjectId, ref: 'Product' }

});

module.exports = mongoose.model('Order', orderSchema);

Populate with product:

Order.find({})
     .populate('product')
     .exec()
     .then(document => {
       // handle the document...
     });

Hope this helps!

edited Jul 5, 2018 at 8:39

answered Jul 4, 2018 at 20:51

dotnetdev4president

5524 silver badges9 bronze badges

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

Comments

ankurnarkhede · Accepted Answer · 2018-12-14 06:55:42Z

Order.find({}, '_id product quantity', function (err, result) {

        if (result) {
            const response = {
                count: result.length,
                createdOrder: result.map(function (order) {
                    return {
                        _id: order._id,
                        productId: order.product,
                        quantity: order.quantity,
                        request: {
                            type: 'GET',
                            url: 'http://localhost:3000/orders/' + order._id
                        }
                    }

                })
            };

            res.status(200).json(response);
        }
        else if (err) {
            console.log(err);
            res.status(404).json(
                {
                    error: err
                });
        }
}).populate('product', '_id name price');

The populate method can be used in javascript syntax like the above.

Collectives™ on Stack Overflow

How to use populate method with MongoDB in Node.js?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related