How to push new field in array mongodb

Question

Imagine I have database like

{
    "_id" : ObjectId("594994d1ab6c161168aa5969"),
    "user_id" : ObjectId("594994d1ab6c161168aa5968"),
    "active" : [ 
        {
            "type" : "active"
        }, 
        {
            "type" : "inactive"
        }
    ]
}

I want add to first object in active array . Here is result I expected

{
    "_id" : ObjectId("594994d1ab6c161168aa5969"),
    "user_id" : ObjectId("594994d1ab6c161168aa5968"),
    "active" : [ 
        {
            "type" : "active",
            "note": [{
                            content: 'here is content',
                            title : ' here is title'
                        }]
        }, 
        {
            "type" : "inactive"
        }
    ]
}

Here is code I tried

db.collection('..').update({'user_id' : ObjectId(userId)} ,
{$push:{ "active.0": "note": [{
                              content: 'here is content',
                                title : ' here is title'
                        }]  } )

But I get The field 'active.0' must be an array but is of type object in document . Where is my wrong ? Please help

Should be {$push:{ "active.0.note": { content: 'here is content', title : ' here is title' } } } — Neil Lunn
– Neil Lunn, Commented Jun 20, 2017 at 8:13
@NeilLunn I tried this and it create new field active[0] in db — Thanh Tùng
– Thanh Tùng, Commented Jun 20, 2017 at 8:19
Nope that did not. Your previous statement did. You need to remove that from the document and reset to what you had before. — Neil Lunn
– Neil Lunn, Commented Jun 20, 2017 at 8:21

Neil Lunn · Accepted Answer · 2017-06-20 08:30:13Z

Starting with your document like this:

{
    "_id" : ObjectId("594994d1ab6c161168aa5969"),
    "user_id" : ObjectId("594994d1ab6c161168aa5968"),
    "active" : [ 
        {
            "type" : "active"
        }, 
        {
            "type" : "inactive"
        }
    ]
}

You run the $push like this:

db.collection.update(
  { "_id" : ObjectId("594994d1ab6c161168aa5969") },
  { "$push":{ "active.0.note": { content: 'here is content', title : ' here is title' } } }
)

Which creates the new array within the first element like so:

{
        "_id" : ObjectId("594994d1ab6c161168aa5969"),
        "user_id" : ObjectId("594994d1ab6c161168aa5968"),
        "active" : [
                {
                        "type" : "active",
                        "note" : [
                                {
                                        "content" : "here is content",
                                        "title" : " here is title"
                                }
                        ]
                },
                {
                        "type" : "inactive"
                }
        ]
}

Everything here is cut and paste from my shell.

Collectives™ on Stack Overflow

How to push new field in array 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