Update deep nested array (not a array of documents/objects) in mongoDB

Question

I have a document which looks like:

{
    _id: 'random123',
    days: [
        {
            _id: "1a",
            day: "Monday",
            tasks: ["shopping", "playing", "movie"]
        },
        {
            _id: "1b",
            day: "Tuesday",
            tasks: ["office", "travel", "relax"]
        },
    ]
}

Now I want to update "office" to "enjoy" in document of id "1b" of days array

I've tried achieving it using following code's

await Schema.updateOne({_id: ObjectId("random123")}, {$set: {"days.$[outer].$[inner]": "enjoy"}}, {arrayFilters: [{"outer._id": ObjectId("1b")}, {"inner.food": "office"}]})

This one code even throws an error

await Schema.updateOne({_id: ObjectId("random123")}, {$set: {"days.$[outer].tasks.$[inner]": "enjoy"}}, {arrayFilters: [{"outer._id": ObjectId("1b")}, {"inner.food": "office"}]})
await Schema.updateOne({_id: ObjectId("random123"), days: {$elemMatch: {"_id": ObjectId("1b"), "tasks": "office"}}}, {$set: {"foods.$[outer].$[inner]": "enjoy"}}, {arrayFilters: [{"outer._id": ObjectId("1b")}, {"inner.food": "office"}]})

None of above code works; execpt 2nd, neither of them throws any error

I am unable to find any solution to this neither on stackoverflow nor on mongoDB official documentation

ray · Accepted Answer · 2021-10-08 05:55:52Z

1

Try to use $[] in your $addToSet for multiple positional element

db.collection.update({
  _id: "random123"
},
{
  $set: {
    "days.$[d].tasks.$[t]": "enjoy"
  }
},
{
  arrayFilters: [
    {
      "d._id": "1b"
    },
    {
      "t": "office"
    }
  ]
})

Mongo playground

Official documentation for identifier $[]

answered Oct 8, 2021 at 5:55

ray

15.6k12 gold badges98 silver badges105 bronze badges

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

1 Comment

Samarth Mittal Over a year ago

Thanks a lot, I was banging my head over this since 4 hours, tried everything but nothing worked. And it turned to be a simple solution.

YuTing · Accepted Answer · 2021-10-08 05:56:29Z

1

use arrayFilter

db.collection.update({
  "days._id": "1b",
  "days.tasks": "office"
},
{
  "$set": {
    "days.$[item].tasks.$[element]": "enjoy"
  }
},
{
  arrayFilters: [
    {
      "item._id": "1b"
    },
    {
      "element": "office"
    }
  ],
  multi: true
})

mongoplayground

answered Oct 8, 2021 at 5:56

YuTing

6,6692 gold badges8 silver badges19 bronze badges

Collectives™ on Stack Overflow

Update deep nested array (not a array of documents/objects) in mongoDB

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related