MongoDB UpdateMany Child Array without filter

Question

Simple Schema:

[
  {
    "key": 1,
    "Array": [
      {
        "Prop1": 1,
        "Prop2": 2
      },
      {
        "Prop1": 2,
        "Prop2": 3
      },
      
    ]
  },
]

I want to update all child array, but mongo says 'The positional operator did not find the match needed from the query.'

db.collection.update({},
{
  "$set": {
    "Array.$.Prop1": ""
  }
},
{
  "multi": true,
  "upsert": false
})

https://mongoplayground.net/p/na-f-4fbesd – chridam Apr 07 '22 at 19:23 — chridam, Apr 07 '22 at 19:23

score 2 · Accepted Answer · answered Apr 07 '22 at 19:18

2

Maybe something like this:

 db.collection.update({},
 {
   "$set": {
     "Array.$[].Prop1": ""
    }
  },
  {
    "multi": true,
    "upsert": false
  })

playground

answered Apr 07 '22 at 19:18

R2D2

9,410
2
12
28

MongoDB UpdateMany Child Array without filter

1 Answers1