Update Elements in Array

Question

Lets say I have this Object:

{town_id: 13, houses_data: [
    {house_id: 5, price: 32, description: "thats a house"},
    {house_id: 2, price: 12, description: "thats a house"}
   ]
 }

And I want to update the desription of house with id 5 to "sold":

{town_id: 13, houses_data: [
    {house_id: 5, price: 32, description: "sold"},
    {house_id: 2, price: 12, description: "thats a house"}
   ]
 }

What I tried:

 town1 = town.findOne({town_id: 13});

Get the houses_data:

 twon1.houses_data

And tried to update only the house_data where id = 5

 twon1.houses_data.find({house_id: 5}).update(description: "sold");

But I get this error message:

 [object Object],[object Object] has no method 'find'

What do I wrong? Thanks

Sylvain Leroux · Accepted Answer · 2015-05-02 23:02:45Z

2

You might use $ to update the first embedded document matching the given query:

db.test.town.update({town_id: 13, "houses_data.house_id":5},
                    {$set: { "houses_data.$.description": "sold"}})

edited May 2, 2015 at 23:02

answered May 2, 2015 at 22:52

Sylvain Leroux

52.3k8 gold badges114 silver badges136 bronze badges

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

Collectives™ on Stack Overflow

Update Elements in Array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related