MongoDB - Update an object from a nested array

Question

{ _id: 1, first : "Maria",
    travel : [
    { country: "Canada", visits: 3, rating: 7 },
    { country: "Poland", visits: 1, rating: 8 },
    { country: "Thailand", visits: 2, rating: 9 } ] },

{ _id: 2, first : "Chen",
    travel : [
    { country: "Thailand", visits: 3, rating: 7 },
    { country: "Canada", visits: 2, rating: 9 },
    { country: "Costa Rica", visits: 4, rating: 8 } ] },

{ _id: 3, first : "Gladys",
    travel : [
    { country: "Canada", visits: 1, rating: 8 },
    { country: "Thailand", visits: 2, rating: 9 },
    { country: "Australia", visits: 3, rating: 10 } ]}
])

I need to update the visits Maria made to Canada to 5, so I have to use some sort of "double filter" (?) But I'm not sure how to do that

Grefuwan · Accepted Answer · 2022-02-12 20:18:32Z

1

Okay, I got how to make that "double filter" : Array filters and $[identifier] Here

db.viajeros.updateOne(  { first: "Maria"},
                        { $set: {"travel.$[elem].visits": 5}},
                        { arrayFilters: [{"elem.country": "Canada"}]}   )

answered Feb 12, 2022 at 20:18

Grefuwan

93 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Update an object from a nested 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