MONGODB : ADD New Key Value in Array

Question

Below is my array where i want to add new Key Value:---

"color" : [
            {
                    "name" : "Blue"
            },
            {
                    "name" : "Red"
            }
    ]

I want to insert new key value as a green color into my array,like this;
"color" : [
          {
                "name" : "Blue"
        },
        {
                "name" : "Red"
        },
        {
                "name" : "Green"
        }]

How to add new key value into array,help me,thanks in advance.

Shaishab Roy · Accepted Answer · 2016-12-06T05:56:26.210

0

To add new key: val in an array you can use $push in update in update

db.collectionName.update(query,{ $push: { "array": obj }},option, callback);

like:

var newObj = {"name":"green"};
db.collectionName.update({_id: givenId},
       { $push: { "color": newObj }},
       function(err, result) {
         if(err) {
           // return  error
         }
        //return success
});

to add multiple key: value can use $each and $push like this code

var keyValArray= [{"name":"green"},{"name":"white"}];
db.collectionName.update({_id: givenId},
       { $push: { "color": {$each: keyValArray} }},
       function(err, result) {
          if(err) {
             // return  error
          }
          //return success
});

edited Dec 06 '16 at 05:56

answered Dec 06 '16 at 05:02

Shaishab Roy

16,335
7
50
68

model name means? – Neha B Dec 06 '16 at 05:07
instead of `ModelName` use `db.collectionName` – Shaishab Roy Dec 06 '16 at 05:08
"errmsg" : "The field 'color' must be an array but is of type Object in document {_id: ObjectId('55b85a63e9a22d5624711eb3')}" its giving this error – Neha B Dec 06 '16 at 05:25
that means in your collection `color` is not an array – Shaishab Roy Dec 06 '16 at 05:28
if your `color` is array that you shown in question then should be working. check again your structure. or for that id can check the structure using any GUI – Shaishab Roy Dec 06 '16 at 05:31
var newObj = {"name":"yellow"}; db.MYCOL.update({"_id" : ObjectId("55b85a63e9a22d5624711eb3")}, { $push: { "color": newObj }}, function(err, result) { if(err) { // return error } //return success }); i am running like this – Neha B Dec 06 '16 at 05:40
what happening if used `{"_id" :"55b85a63e9a22d5624711eb3"}` without using ` ObjectId(` – Shaishab Roy Dec 06 '16 at 05:44
working now,i changed match query..and now i want to add multiple key value how we can do? – Neha B Dec 06 '16 at 05:49
are you using any GUI? like: RoboMongo then try there – Shaishab Roy Dec 06 '16 at 05:50
yes i am using mongoBOOSTer ..i want to add multiple? – Neha B Dec 06 '16 at 05:51
should not because I checked also in my end – Shaishab Roy Dec 06 '16 at 06:01
its coming like [ { "Name" : "green" }, { "Name" : "white" } ] ] – Neha B Dec 06 '16 at 06:13
no it coming like "color" : [ { "name" : "Blue" }, { "name" : "Red" }, [{ "name" : "Green" },{"name":"white"}]] its coming like this – Neha B Dec 06 '16 at 06:55
you may not used `$each` look at the second query. In this query used `$each` – Shaishab Roy Dec 06 '16 at 06:59

score -1 · Answer 2 · edited May 23 '17 at 10:29

-1

You can either do a push or an update. This can give you an insight:

ex:

db.col.update(
    { name: 'doc'}, 
    {$push: {'color': {name: 'Green'}}}
)

edited May 23 '17 at 10:29

Community

1
1

answered Dec 06 '16 at 05:01

Jehoshuah

671
2
9
20

MONGODB : ADD New Key Value in Array

2 Answers2