Mongoose update array value

Question

How to update array value in mongoose ?

This is my schema

var cars = new Schema({
    brand : String,
    prices:[ {color : String, price: String}]
}





   let carID = req.body.carID;
   let brandPriceArraySingleID = req.body.brandPriceArraySingleID;
    
    var ObjectId = require('mongoose').Types.ObjectId; 
    var query = { 'prices.id' : new ObjectId(brandPriceArraySingleID) };
    
    let carsPriceUpdate = await cars.findOneAndUpdate(query, { $set: { "price": "new price" } });

This above code is not working!!

Questions

How to find and update array value?
Do I need to check whether exist carID in cars model before array value find?

What is the value for brandPriceArraySingleID and what do you want to update? All prices? An specific price for a color in a brand? — J.F.
– J.F., Commented Feb 17, 2022 at 15:37

Kaushik Makwana · Accepted Answer · 2022-02-25 06:24:43Z

1

If you want to update the Array fields element from the query, you need to use $ in the field, ex : { "prices.$.price": "new price" }

Try this code.

   const query = {
     _id : req.body.carID,
     "prices._id" : req.body.brandPriceArraySingleID
    }

  let carsPriceUpdate = await cars.findOneAndUpdate(query, { $set: { "prices.$.price": "new price" },{ returnDocument: 'after' }});

   console.log(carsPriceUpdate)

You need to set new value for the object's property ( $ reflects the position).
{ returnDocument: 'after' } is options of query. it's return document after updating.

edited Feb 25, 2022 at 6:24

Kaushik Makwana

2,58610 gold badges37 silver badges57 bronze badges

answered Feb 25, 2022 at 6:15

Prit Hirpara

1981 silver badge10 bronze badges

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

Collectives™ on Stack Overflow

Mongoose update array value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related