Pick content from DB while using update query in Mongodb?

Question

I want to update all the database :-

Their are Models like:

{
    "_id" : ObjectId("593800da81dd4240d42f0c98"),
    "leaveType" : ObjectId("5927da8b7094b726fecaa3b5"),
    "units" : 20,
    "employee" : ObjectId("59283f772c3bd82eaca28153"),
    "__v" : 0
}

What I want is, update all the models with inserting new value as unitsAvailed with making same Number as Corresponding units

{
    "_id" : ObjectId("593800da81dd4240d42f0c98"),
    "leaveType" : ObjectId("5927da8b7094b726fecaa3b5"),
    "units" : 20,
    "unitsAvailed" : 20,
    "employee" : ObjectId("59283f772c3bd82eaca28153"),
    "__v" : 0
}

Shaishab Roy · Answer 1 · 2017-07-18T11:58:58.113

0

you can use this query to update all documents

var cursor = db.collectionName.find({});
cursor.forEach(function(data) {
  data.unitsAvailed = data.units;
  data.save();
});

edited Jul 18 '17 at 11:58

answered Jul 18 '17 at 11:48

Shaishab Roy

16,335
7
50
68

score 0 · Answer 2 · answered Jul 18 '17 at 11:53

0

You can run server-side code with db.eval().see below example

 db.eval(function() { 
  db.collection.find({tag : "refurb"}).forEach(function(e) {
    e.Price = e.Price * 0.5;
    db.collection.save(e);
  });
});

see Multiply field by value in Mongodb

answered Jul 18 '17 at 11:53

Nitu Bansal

3,826
3
18
24

i want to make query direct on mongo shell . will this work at that place – hardy Jul 18 '17 at 12:43
@hardy if you are authorized you an do it on mongo shell. – Nitu Bansal Jul 19 '17 at 05:52

score -1 · Answer 3 · edited Jul 18 '17 at 14:40

-1

You can use this:

 db.collectionName.updateMany({},{$set:{unitsAvailed: 20}})

edited Jul 18 '17 at 14:40

Massimiliano Kraus

3,638
5
27
47

answered Jul 18 '17 at 12:03

Ahmed Yasser

1
2

Pick content from DB while using update query in Mongodb?

3 Answers3