MongoDB add a field to a embedded document in an array

Question

Hello I am new to MongoDB and i have been looking for a way to add a field to a embedded document in an array

// collection

> db.test.find().pretty();
{
    "_id" : ObjectId("5761765a31356152793c8790"),
    "name" : "bb",
    "email" : "bb@mail",
    "projects" : [
        {
            "project_id" : ObjectId("576179bf31356152793c879c")
             //How can i add a name here
        }
    ]
}
>

You want to add same name for both project_id? or specific name for each? — Medet Tleukabiluly
– Medet Tleukabiluly, Commented Jun 15, 2016 at 16:12
a different name i just want to be able to access the projects.project_id — vic-3
– vic-3, Commented Jun 15, 2016 at 16:14
@slugonamission I tried this db.test.update({name:'bb'},{$set :{projects.0.name:'foo'}}) and it gives me this error SyntaxError: Unexpected number — vic-3
– vic-3, Commented Jun 16, 2016 at 8:34

vic-3 · Accepted Answer · 2016-06-16 09:21:08Z

6

Figured it out :) db.test.update({projects:{$elemMatch:{"project_id" : ObjectId("576179bf31356152793c879c")}}},{$set :{'projects.$.name':'foo'}},true); Hope it helps someone Thank you !

answered Jun 16, 2016 at 9:21

vic-3

9941 gold badge10 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

MongoDB add a field to a embedded document in an array

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