How to add document in existing nested documents dynamically in mongodb

Question

i have following structure

{
  "name": "abc",
  "lname": "xyz",
  "data": {
    "1": {
      "info": {
        "test": "test"
      },
      "info1": {
        "test": "test"
      }
    }
  }
}

now i want to add following object in 'data' object

 "2": {
      "info": {
        "test": "test1"
      },
      "info1": {
        "test": "test1"
      }
    }

how to do that in mongodb using mongodb java driver?

Yathish Manjunath · Accepted Answer · 2015-07-15 07:52:37Z

2

In MongoDB shell you can do it as below :

db.collection.update( {_id:id} , { $set: { "data.2": 
  {
 "info": {"test": "test1" }, "info1": {"test": "test1"}
  } 
}});

In Java driver :

DBObject query = new BasicDBObject("_id", "123"); 
DBObject update = new BasicDBObject(); 
DBObject info = new BasicDBObject("test","test1");
update.put("$set", new BasicDBObject("data.2",
new BasicDBObject("info",info).append("info1",info)); 

collection.update(query, update);

edited Jul 15, 2015 at 7:52

answered Jul 15, 2015 at 6:40

Yathish Manjunath

2,0371 gold badge17 silver badges24 bronze badges

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

6 Comments

Shital Over a year ago

thank you yathish for response. this query executed successfully but not appending data to existing document object

Yathish Manjunath Over a year ago

oops!! instead of "data.2" field i had used "name.2" i have updated the same in the post.

Shital Over a year ago

i was already made that change in my mongo query but then also it is not working :( have you tested the same?

Yathish Manjunath Over a year ago

yes i have tested the query in the mongo shell.. its working fine.. can u share the results which you are getting after executing this query ?

Shital Over a year ago

{ "_id" : ObjectId("55a6090062aefdae06f290b0"), "name" : "abc", "lname" : "xyz", "data" : { "1" : { "info" : { "test" : "test" }, "info1" : { "test" : "test" } } } } i have this record in my test databse and i am running following query db.test1.update( {name:"abc"},{ $set: { "data.2": { "info": {"test": "test1" }, "info1": {"test": "test1"} } }}); this shows nothing in console and my data remains same in database

|

Collectives™ on Stack Overflow

How to add document in existing nested documents dynamically in mongodb

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related