how to update value in a nested array mongodb?

Question

I want to update all documents in my collection that have a specific value that resides inside a nested array that is structured like this:

[{
  "_id": "1",
  "arrayX": [
    {
      "id2": "123", 
      "arrayY": [
        {
          "colour": "blue",
          "size": "small"
        },
        {
          "colour": "red",
          "size": "small"
        },
      ]
    },
    {
      "id2": "12345", 
      "arrayY": [
        {
          "colour": "blue",
          "size": "small"
        },
        {
          "colour": "purple",
          "size": "small"
        },
      ]
    }
  ]
}]

In this case, I need to update the value "blue" to "white" in the 2 elements that are presented in the example above.

I came up with something like this but it's not working:

db.collection.update(
   { arrayX.$.arrayY.$.colour: "blue" },
   { $set: { "arrayX.$.arrayY.$.colour" : "white" } },
   { upsert: false }
)

Thanks in advance

Does this answer your question? Insert into highly nested document MongoDB — ray
– ray, Commented Aug 2, 2021 at 1:31

turivishal · Accepted Answer · 2021-08-02 07:37:48Z

1

Try arrayFilters, to update specific element in nested array and $[] to update all elements,

db.collection.updateMany(
  { "arrayX.arrayY.colour": "blue" },
  {
    $set: {
      "arrayX.$[].arrayY.$[c].colour": "white"
    }
  },
  {
    arrayFilters: [
      { "c.colour": "blue" }
    ]
  }
)

Playground

answered Aug 2, 2021 at 7:37

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

how to update value in a nested array mongodb?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related