want to push value in nested array in mongo using nodejs

Question

I have a nested array "orders" in my collection "customers" array. I want to push value in orders corresponding to particular _id. How to do it using nodejs ?
This is how my array looks like. My collection name is "customers".

  {
        "_id":"5a696e875dceae1e40da3c00",
        "name":"John",
        "address":"6lacewood crescent road",
    "city":"Toronto",
    "state":"Ottawa",
    "email":"[email protected]",
    "zipcode":"123456",
    "gender":"1",
    "orders": [
    {
    "product":"Basket",
    "date":"2014-09-13T18:30:00.000Z",
    "Quantity":1,
"Unitprice":29.99
    },
    {
    "product":"Basket",
    "date":"2014-08-31T18:30:00.000Z",
    "Quantity":2,
"Unitprice":29.99
    },
    {
    "product":"Controller",
    "date":"2014-08-13T18:30:00.000Z",
    "Quantity":3,
"Unitprice":39.99
    }
    ]

I want to push another order in orders array. How to do it using nodejs ?

nodejs

app.post('/addorders:id', function(req, res, next){

   console.log(req.params.id);

    var body = req.body;
        console.log('update command');
       dbConn.then(function(db) {


       var dd = db.db("customermanagement");
  console.log('update command');
       dd.collection("customers").findByIdAndUpdate( ObjectId(req.params.id), {$push : {orders : body}}, function(err,doc){
    if(err) console.error(err)    
    console.log('pushed')    
});

       });
});

Do you use mongoose?

Sridhar
– Sridhar

2018-01-30 04:41:05 +00:00
Commented Jan 30, 2018 at 4:41 — Sridhar
– Sridhar, Commented Jan 30, 2018 at 4:41

harpreet cheema · Accepted Answer · 2018-01-30 04:56:34Z

This is used for add new order in customer object

var cond = {
              _id: ObjectId("5a587b0ca3f8b34cc3f3cfe4"),//CustomerID
           };
var set = {
             $push: {
                order: {
                      product: "xyz",
                      Quantity: 5, 
                      Unitprice:10                 
                   }
             }
       };

You can use this way for edit order from customer object

var cond = {
         _id: ObjectId("5a587b0ca3f8b34cc3f3cfe4"),// Here customer ID is a _id of customer object
         "orders": {
              $elemMatch: { _id: ObjectId("5a587b0ca3f8b34cc3f3cfe5") }//Here You can match _id of object array of customer or you can match any other field.
          }
       };
var set = {
          $set: {
              "orders.$.product":"Abc"//Here you can also update multiple fields
          }
    };


Models. customers.findOneAndUpdate(cond, set, 
   function(err, res) {
        if (err) 
            console.log(err);
        else
            console.log(res)
 });

Saravana · Accepted Answer · 2018-01-30 05:09:08Z

0

using findByIdAndUpdate

let id = ObjectId("5a6ff7cf7863fc1242ebf086") // change this to customer_id
let order = {product:"something"}

Customers.findByIdAndUpdate(id, {$push : {orders : order}}, function(err,doc){
    if(err) console.error(err)    
    console.log('pushed')    
})

edited Jan 30, 2018 at 5:09

answered Jan 30, 2018 at 4:50

Saravana

12.8k2 gold badges42 silver badges60 bronze badges

Collectives™ on Stack Overflow

want to push value in nested array in mongo using nodejs

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