Insert data into inner array in MongoDB

Question

I have a little problem, hope You can help me. I have next array structure in MongoDB:

{
"_id":ObjectId("4e43cf96e7c7914b87d2e0ff"),
"list" :[
    {
    "id" : ObjectId("4e43cf96e62883ee06000002"),
    "user_name" : "login",
    "comments" : [ ]  //insert here new data
    },
    {
    "id" : ObjectId("4e43cf96e62883ee06000003"),
    "user_name" : "login",
    "comments" : [ ]
    }
]
}

And I want to insert new data to comments by "list.id". But I try like that:

$post_id = "4e43cf96e62883ee06000002";
$this->connection->user->feed->update(
    array ('list.id' => new MongoId($post_id) ), 
    array ('$push' => array ('list'=>array('comments'=>$data ) ))
)

But that code create new field in structure, but not add data to field 'comments':

{
"_id":ObjectId("4e43cf96e7c7914b87d2e0ff"),
"list" :[
     {
     "id" : ObjectId("4e43cf96e62883ee06000002"),
     "user_name" : "login",
     "comments" : [ ]  //insert here new data
     },    
     {
     "id" : ObjectId("4e43cf96e62883ee06000003"),
     "user_name" : "login",
     "comments" : [ ]
     },            
     {
     "comments" : { //added new field
        //there is my data
     }
]
}

Also I tried:

$this->connection->user->feed->update(
     array ('list.id' => new MongoId($post_id) ), 
     array ('$push' => array ('list.comments'=>$data ) ) 
  );

But nothing.

Igorekk · Accepted Answer · 2011-08-11 13:48:22Z

10

This works fine in mongo console :)

db.yar.update({"list.id":ObjectId("4e43cf96e62883ee06000002")}, {"$addToSet":{"list.$.comments":"my cool comment"}});

answered Aug 11, 2011 at 13:48

Igorekk

2561 silver badge8 bronze badges

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

2 Comments

Yaroslav Boichuk Over a year ago

yea, You're right;) thank You a lot!! And can You tell me please what does char "$" means in "list.$.comments"? Or give me a reference? Thanks!

Igorekk Over a year ago

Link to doc

Igorekk · Accepted Answer · 2011-08-11 13:24:21Z

1

Use $addToSet modifier, because comments is a array not field.

answered Aug 11, 2011 at 13:24

Igorekk

2561 silver badge8 bronze badges

2 Comments

Yaroslav Boichuk Over a year ago

I change '$push' to '$addToSet', but that code has same behavior as with '$push' (add new field, I show example in question)

Yaroslav Boichuk Over a year ago

and also I use '$push' to add data to 'list' array, and it works with '$push'.

Collectives™ on Stack Overflow

Insert data into inner array in MongoDB

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related