MongoDB insert object inside an object

Question

Please suggest me on how to insert an object inside an object. Sample collection

{
"_id" : ObjectId("57556cec9d66a6c26b19ce06"),
"email" : "[email protected]",
"password" : "1235466",
"typeOfUser" : 1,
"userDetails" : {
    "firstName" : "David",
    "lastName" : "Beckham",
    "contactNumber" : "12345678989"
}

}

I would like to add another object called address object inside this. something like this

{
"_id" : ObjectId("57556cec9d66a6c26b19ce06"),
"email" : "[email protected]",
"password" : "1235466",
"typeOfUser" : 1,
"userDetails" : {
    "firstName" : "David",
    "lastName" : "Beckham",
    "contactNumber" : "12345678989"
     "address" : {
        "country" : "",
        "state" : ""
     }
  }

}

Please suggest me on how to insert values for address object..

What I have tried?

db.getCollection('PetCare').update({"contactNumber":"12345678989"},{"$push":{"address":{"country":"India","city":"Blore"}}})

but it does not update..

Celia · Accepted Answer · 2016-06-06 13:37:33Z

7

Try the following:

db.getCollection('PetCare').update({"userDetails.contactNumber":"12345678989"},{"$set":{"userDetails.address":{"country":"India","city":"Blore"}}})

answered Jun 6, 2016 at 13:37

Celia

3551 silver badge8 bronze badges

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

Comments

Jonathan Michalik · Accepted Answer · 2016-06-06 13:29:03Z

3

The $push operator you're currently using is intended to add a value to an array, so that won't get the job done here.

If you're wanting to update a document with a new property, you'll want to use the $set operator:

db.test.update({contactNumber: "xxx"}, {$set: {address: {country: "India", city: "Blore"}}})

answered Jun 6, 2016 at 13:29

Jonathan Michalik

1,54214 silver badges15 bronze badges

Comments

perona chan · Accepted Answer · 2021-01-29 17:53:34Z

-1

please find the below code, its working as expected

worked !!

cmiw !!

db.getCollection('PetCare').update(
  {"email" : "[email protected]"},
  {"$set":
    {"userDetails.address":
      {"country":"India","city":"Blore"}
    }
})

edited Jan 29, 2021 at 17:53

answered Jan 27, 2021 at 13:20

perona chan

3014 silver badges10 bronze badges

1 Comment

David Makogon Over a year ago

Aside from a different property to look up a document (which is not the same as the OP specified), this is identical to an already-posted, upvoted, accepted answer from almost 5 years ago.

Collectives™ on Stack Overflow

MongoDB insert object inside an object

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related