Update multiple conditions array in MongoDB

Question

I have this data :

{
  'id': '1',
  'object': [
     {'code': 'a'},
     {'code': 'b'},
     {'code': 'c'}
  ]
}

And this query :

db.test.update({
    'id': '1',
    'object': {
        '$elemMatch': {
            '$or': [
                {'code': 'b'},
                {'code': 'c'}
            ]
        }
    }
},
    {'$set':{'object.$.test':'ok'}}
)

Documents can contain one of these codes, both or none.
It works well with documents with one condition fulfilled.

In the case if there are 2 codes in the document, only the first one is updated :
I want to update both of them (code: 'b' AND code: 'c')

{
  'id': '1',
  'object': [
     {'code': 'a', 'test': 'ok'},
     {'code': 'b'}
  ]
}

This is what I want :

{
  'id': '1',
  'object': [
     {'code': 'a', 'test': 'ok'},
     {'code': 'b', 'test': 'ok'}
  ]
}

Thank you for helping.

the $ positional will update first matching element, for multiple elements update use arrayFilters. — turivishal
– turivishal, Commented Jun 21, 2021 at 9:27

hhharsha36 · Accepted Answer · 2021-06-21 09:30:53Z

2

You have to make use of $[identifier] update and pass the conditions in arrayFilters since $ will update only a single record as pointed by @turivishal

db.collection.update({
  "id": "1",
  "object.code": {
    "$in": [
      "b",
      "c"
    ]
  }
},
{
  "$set": {
    "object.$[elem].code": "ok"
  }
},
{
  arrayFilters: [
    {
      "elem.code": {
        "$in": [
          "b",
          "c"
        ]
      }
    }
  ],
},
)

Mongo Playground Sample Execution

answered Jun 21, 2021 at 9:30

hhharsha36

3,3892 gold badges14 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Update multiple conditions array in MongoDB

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