MongoDB Update Item in Array inside Array

Question

I want to update an existing item inside of an array in an array.

The structure of my document looks like the following:

    {
  "_id":"a1",
  "projects":[{
    "_id": "b1",
    "title":"Title A",
    "task":[
           {"_id": "c1",
            "title":"Title B"},
            {"_id": "c2",
            "title":"Title C"},
            {"_id": "c3",
            "title":"Title D"}
          ],

}]
}

Let's say we want to change the "task" :

{"_id": "c2",
 "title":"Title C"}

to

{"_id": "c2",
 "title":"Title C1"}

Does someone know a proper way to update this subdocument?

eol · Accepted Answer · 2020-05-06 08:29:41Z

1

By using a combination of $set with the posititonal operator and arrayFilters, this should be doable:

db.getCollection('so-test').updateOne(
   { _id: "a1"},
   { $set: { "projects.$[].task.$[task].title": "Title C1" } },
   { arrayFilters: [  {"task.title": "Title C"} ]}
)

answered May 6, 2020 at 8:29

eol

24.7k6 gold badges53 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Update Item in Array inside Array

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