Update array with multiple conditions in mongodb

Question

I have this document:

{
    "_id" : ObjectId("5b673f525ef92ec6ef16504e"),
    "events" : [ 
        {
            "name" : "Winner",
            "map" : 0,
            "something" : []
        }, 
        {
            "name" : "Winner",
            "map" : 2,
            "something" : []
        }, 
        {
            "name" : "DifferentName",
            "map" : 2,
            "something" : []
        }
    ]
}

If I run the following update:

db.getCollection('test').updateOne({
    "_id": ObjectId("5b673f525ef92ec6ef16504e"),
    "events.name": "Winner",
    "events.map": 2
},
{$push: {
        "events.$.something": {
                something: "test",
        }
    }
})

I get the bad result:

{
    "_id" : ObjectId("5b673f525ef92ec6ef16504e"),
    "events" : [ 
        {
            "name" : "Winner",
            "map" : 0,
            "something" : [ 
                {
                    "something" : "test"
                }
            ]
        }, 
        {
            "name" : "Winner",
            "map" : 2,
            "something" : []
        }, 
        {
            "name" : "DifferentName",
            "map" : 2,
            "something" : []
        }
    ]
}

This is wrong, because "something" : "test" should be in the second element, where the map is equal to 2.

If I change the field "name" to "a" and run the same update, then I get the right result:

{
    "_id" : ObjectId("5b673f525ef92ec6ef16504e"),
    "events" : [ 
        {
            "a" : "Winner",
            "map" : 0,
            "something" : []
        }, 
        {
            "a" : "Winner",
            "map" : 2,
            "something" : [ 
                {
                    "something" : "test"
                }
            ]
        }, 
        {
            "a" : "DifferentName",
            "map" : 2,
            "something" : []
        }
    ]
}

Now you can see, that "something" : "test" is in the right place (second event). Is this because I have used "name" and "name" is some kind of reserved keyword in Mongo?

Ashh · Accepted Answer · 2018-08-05 20:38:29Z

5

When there are multiple conditions to match inside an array then the .Dot notation doesn't work with update query.

You need to use $elemMatch to match exact two fields inside an array

db.getCollection('test').updateOne(
  {
    "_id": ObjectId("5b673f525ef92ec6ef16504e"),
    "events": { "$elemMatch": { "name": "Winner", "map": 2 }}
  },
  {
    "$push": { "events.$.something": { "something": "test" }}
  }
)

edited Aug 5, 2018 at 20:38

answered Aug 5, 2018 at 20:24

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Update array with multiple conditions in 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