Mongodb array $push and $pull

Question

I was looking to pull some value from array and simultaneously trying to update it.

    userSchema.statics.experience = function (id,xper,delet,callback) {     var update = {       $pull:{         'profile.experience' : delet       },          $push: {           'profile.experience': xper         }   };   this.findByIdAndUpdate(id,update,{ 'new': true},function(err,doc) {     if (err) {       callback(err);     } else if(doc){       callback(null,doc);     }   }); }; 

i was getting error like:

MongoError: exception: Cannot update 'profile.experience' and 'profile.experience' at the same time

Answer 1

I found this explanation:

The issue is that MongoDB doesn’t allow multiple operations on the same property in the same update call. This means that the two operations must happen in two individually atomic operations.

And you can read that posts:

Pull and addtoset at the same time with mongo

multiple mongo update operator in a single statement?

Answer 2

In case you need replace one array value to another, you can use arrayFilters for update.

(at least, present in mongo 4.2.1).

db.your_collection.update(     { "_id": ObjectId("your_24_byte_length_id") },     { "$set": { "profile.experience.$[elem]": "new_value" } },     { "arrayFilters": [ { "elem": { "$eq": "old_value" } } ], "multi": true } )  

This will replace all "old_value" array elements with "new_value".