Update specific field in all documents in MongoDB

Question

I have a collection in MongoDB that contains a list of objects. Each object has an array of "updaters" which are objects with a field that I want to update. One of the updaters in that array needs a description updated. How can i update just the descrption of the the updater object, that I know "updaterId" of.

Update:

It appears to me that setting the flag multi: true will do the trick in Mongo 2.2+.

db.configurations.update(
  {"updaters.updaterId": "90391154-67BB-452E-A1A7-A07A98B94F86"},
  {$set: {"updaters.$.description": "This tool will prevent users from Unloading Linked Revit files for \"all users\" which causes such Linked File to be unloaded by default when opening project."}},
  {multi: true}
)

score 2 · Answer 1 · answered Sep 12 '17 at 21:27

2

You can update the description updaterId like this:

db.collection.update( {"updaters.updaterId" : updaterId } ,
               {$set : {"updaters.$.description" : "My description"}} ,
               false ,
               true);

answered Sep 12 '17 at 21:27

Pankaj Jatav

2,158
2
14
22

Doesnt this only update a single entry? I have multiple objects with the same updaterId and I am trying to change them all at once. Is that possible? – konrad Sep 12 '17 at 21:39
For now no. Using $in also it will only update the first id in array. – Pankaj Jatav Sep 12 '17 at 21:46
So I suggest to you use loop. If your dataset is huge, You can go with mongo bulk update. – Pankaj Jatav Sep 12 '17 at 21:49

Update specific field in all documents in MongoDB

1 Answers1