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

1. Find document by _id

2. find matching object in array by _id

3. 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);

• Takis: to get answer faster , if you can give sample data in and sample data out(the expected output that you want)

Answer 1

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)
})

• Brendan Little: This worked thank you so much, very nice way of doing it