Updating deep data array on mongodb

Question

I am trying to push an object to the deeply nested checklist array below :

{
 // User
  _id : "id",
  days : [
     {
       _id : "id"
       day : "6",
       tasks: [
          {
            _id : "id",
            name : "todo"
            types : {
              checklist : [] // i want to push objects here
              notes : []
            }
          },
          ....
       ]
     },
     ....
  ]
}

Here is what i have tried but failed... my guess is that the $ operator shouldn't be at that position:

User.update({_id : user._id , "days.tasks.name": 'todo' } ,{ $push : { 'days.tasks.$.types.checklist' : { data : 'hello World' } }})

You can see here at https://stackoverflow.com/questions/10341151/mongodb-update-deep-array — Nguyen Van Tuan
– Nguyen Van Tuan, Commented Aug 20, 2019 at 7:09

Nguyen Van Tuan · Accepted Answer · 2019-08-20 07:14:16Z

0

Or you can re-design your DB and made some child Model, ref with ObjectId.

answered Aug 20, 2019 at 7:14

Nguyen Van Tuan

951 gold badge1 silver badge12 bronze badges

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

Comments

user121548789 · Accepted Answer · 2019-08-21 02:05:25Z

0

I found the solution which basically looking for the index of the specific task using the unique id:

router.patch('/user/updatetask', auth , async (req,res)=>{
    const user = req.user
    const dayIndex = user.days.indexOf(user.days.find(day => day.day == req.body.day))
    const taskIndex = user.days[dayIndex].tasks.indexOf(user.days[dayIndex].tasks.find(task => task._id == req.body.task_id))
    var obj = {}
        obj[`days.${dayIndex}.tasks.${taskIndex}.types.checklist`] = 'no'
    try {

        await  User.updateOne({_id : user._id } ,{ $push :obj})
        res.status(201).send(user)
    } catch(e) {
        res.status(400).send(e)
    }
})

answered Aug 21, 2019 at 2:05

user121548789

1891 silver badge10 bronze badges

Collectives™ on Stack Overflow

Updating deep data array on mongodb

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related