java mongodb update specific with array

Question

I have the following doc stored in MongoDB:

{ 
  "id" : "5101",
  "contractId" : "001",
  "dueId" : [{"id":"001"},{"id":"002"}],
  "overdueAmount" : "",
  "amount" : "",
  "customerContact" : "Humus"
}

and I want to update to follow data:

{ 
  "id" : "5101",
  "contractId" : "001",
  "dueId" : [{"id":"001"},{"id":"002"},{"id":"003"}],
  "overdueAmount" : "200",
  "amount" : "100",
  "customerContact" : "Bim"
}

you can see dueId is updated(insert a element) and amount, overdueAmount, customerContact are also updated.

How can I use mongodb use update?

i want update mongodb by only one update statement.

user3150939
– user3150939

2014-01-07 12:22:18 +00:00
Commented Jan 7, 2014 at 12:22 — user3150939
– user3150939, Commented Jan 7, 2014 at 12:22

Parvin Gasimzade · Accepted Answer · 2014-01-07 12:35:50Z

3

By using $push operator you can add new items into the array and $set operator you can update other fields.

The query should be like :

db.collection.update({"id":"5101"},{$push:{"dueId" : {"id" : "003"}}, $set : {"overdueAmount":"200", "amount" : "100", "customerContact" : "Bim"}})

By using Java driver :

DBCollection coll = ...

DBObject query = new BasicDBObject("id", "5101");

DBObject pushObj = new BasicDBObject("dueId", new BasicDBObject("id", "003"));

DBObject setObj = new BasicDBObject();
setObj.put("overdueAmount", "200");
setObj.put("amount", "100");
setObj.put("customerContact", "Bim");

DBObject updateObj = new BasicDBObject();
updateObj.put("$push", pushObj);
updateObj.put("$set", setObj);

coll.update(query, updateObj);

edited Jan 7, 2014 at 12:35

answered Jan 7, 2014 at 12:24

Parvin Gasimzade

26.1k8 gold badges58 silver badges83 bronze badges

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

1 Comment

user3150939 Over a year ago

but how can i use this in java？

Collectives™ on Stack Overflow

java mongodb update specific with array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related