Mongoose update update nested object inside an array

Question

I'm trying to query and update an element in the rosters array ( roster.schedule.monday.start) & then update the value in this example.

monday.start these two keys need to be dynamic

I think the approach would be something like this

Find document by _id
find matching object in array by _id
update nested values

I have tried this below with no luck, could anybody assist in this problem

many thanks

// Mongoose query

exports.updateRoster = (req, res) => {

  const editDay = req.body.day;
  const value = req.body.valueOfEntry;
  const userId = req.body.id;
  const rosterId = req.body.rosterId;
  const startPerieod = req.body.time;


  let dynObj = {
    ["rosters.$.schedule.$." + editDay + ".$." + startPerieod]: value,
  };


  Carer.updateOne({ "rosters._id": rosterId }, { $set: dynObj }).exec(
    (err, roster) => {
      if (err) {
        return res.status(400).json({
          error: err,
        });
      }
      res.json(roster);
    }
  );
};


// Schema 

const mongoose = require("mongoose");
const { ObjectId } = mongoose.Schema;

const carersSchema = new mongoose.Schema({
 
  
  rosters: [
    {

   schedule: {

     monday: {

       start: { type: String },
       finish: { type: String },
       notes: { type: String },


    }, 
  ],

});

module.exports = mongoose.model("Carers", carersSchema);

to get answer faster , if you can give sample data in and sample data out(the expected output that you want) — Takis
– Takis, Commented Sep 22, 2021 at 12:06

Tharunkumar · Accepted Answer · 2021-09-22 14:31:58Z

4

Try using $set and array filters like in the link

Carer.findOneAndUpdate({_id: carerId}, 
{ 
  "$set": {[`rosters.$[outer].schedule.${editDay}.${startPerieod}`]: value} 
},
{ 
  "arrayFilters": [{ "outer._id": roasterId }]
},
function(err, response) {
  if(err) console.log(err)
  console.log(response)
})

answered Sep 22, 2021 at 14:31

Tharunkumar

1903 silver badges19 bronze badges

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

1 Comment

Brendan Little Over a year ago

This worked thank you so much, very nice way of doing it

Collectives™ on Stack Overflow

Mongoose update update nested object inside an array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related