How to push new key and value in JSON array in mongodb?

Question

How can I push new key and value in JSON array?

I tried I used push keyword in update query but I got a different output. I used:

 db.users.updateOne({"name":"viki"},{$push{"address.district":"thambaram"}})

I have this document:

{ "_id" : ObjectId("58934f10c7592b1494fd9a4d"), "name" : "viki", "age" : 100, "subject" : [ "c", "node.js", "java" ], "address" : { "city" : "chennai", "state" : "tamilnadu", "pincode" : "123" } }

I want to add "district":"thambaram" in address json array

I need like:

{ "_id" : ObjectId("58934f10c7592b1494fd9a4d"), "name" : "viki", "age" : 100, "subject" : [ "c", "node.js", "java" ], "address" : { "city" : "chennai", "state" : "tamilnadu", "pincode" : "123","district":"thambaram"} }

You can not use $push operator because this is not an array. You can use simple nested object property assignment. — Mohit Bhardwaj
– Mohit Bhardwaj, Commented May 4, 2017 at 14:34
i got this output: { "_id" : ObjectId("58934f10c7592b1494fd9a4d"), "name" : "viki", "age" : 100, "subject" : [ "c", "node.js", "java" ], "address" : { "city" : "chennai", "state" : "tamilnadu", "pincode" : "123", "district" : [ "thambaram" ] } } but I need { "_id" : ObjectId("58934f10c7592b1494fd9a4d"), "name" : "viki", "age" : 100, "subject" : [ "c", "node.js", "java" ], "address" : { "city" : "chennai", "state" : "tamilnadu", "pincode" : "123","district":"thambaram"} } — vigneshRavi
– vigneshRavi, Commented May 4, 2017 at 14:36
Kindly accept my answer if it helped you. And we need to use push to add a new element to array. Your's was not an array. — FallAndLearn
– FallAndLearn, Commented May 4, 2017 at 17:32

FallAndLearn · Accepted Answer · 2017-05-04 14:34:27Z

1

Use $set

db.users.updateOne({"name":"viki"},{$set:{"address.district":"thambaram"}})

This should work.

The $push operator appends a specified value to an array. In your case you should use $set

answered May 4, 2017 at 14:34

FallAndLearn

4,1351 gold badge20 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

How to push new key and value in JSON array in mongodb?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related