MongoDB - Update element inside of multiple Arrays

Question

i would like to update Elements that are nested inside of multiple Arrays, like:

{
  _id: 1,
  items:[{
    item_id: 1,
    desc:[{
      desc_id: 1,
      description: "Test entry"
    },
    {
      desc_id: 2,
      description: "Test entry 2"
    }]
  }]
}

How is it possible to edit "description" inside of the first desc element with Node and Mongoose. I tried:

Client.updateOne({"items.desc.desc_id": 1}, {$set:{"items.$.desc.$.description": "Other test entry"}})

nimrod serok · Accepted Answer · 2022-09-12 08:54:09Z

1

If you want to update only the first desc item try:

Client.updateOne({
  "items.desc.desc_id": 1
},
{
  $set: {
    "items.$.desc.0.description": "Other test entry"
  }
})

See how it works on the playground example - by index

EDIT:

You were using the positional $ operator which update the first match. If you want to search the inner array by the desc_id use the $[<identifier>]:

db.collection.update(
  {"items.desc.desc_id": 1},
  {$set: {"items.$.desc.$[item].description": "Other test entry"}},
  {arrayFilters: [{"item.desc_id": 1}]}
)

See how it works on the playground example by desc_id

But you are still using the positional $ operator for the external array, meaning you will only update the first match inside it.

To update all items according the desc_id, use the all positional operator $[] for the external array:

db.collection.update(
  {"items.desc.desc_id": 1},
  {$set: {"items.$[].desc.$[item].description": "Other test entry"}},
  {arrayFilters: [{"item.desc_id": 1}]}
)

See how it works on the playground example all items by desc_id

edited Sep 12, 2022 at 8:54

answered Sep 10, 2022 at 8:28

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

2 Comments

Chris Schl Over a year ago

That isnt really what i am looking for. I dont really want to search them by the Array index, i want to search them by the desc_id.

nimrod serok Over a year ago

Updated the answer accordingly

Collectives™ on Stack Overflow

MongoDB - Update element inside of multiple Arrays

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related