Updating a deeply nested object in mongodb

Question

I'm trying to update the favorite Boolean to true in the following model.

I only need a success/failure return, so I've been trying update with a projection. However, I can't seem to get any further than selecting articles, but am not able to change the favorite value given the title name.

I am using the mongoDB node.js driver

Thanks!

_id: id,
news: [
    { 
      name: bbc,
      articles: [
                  {
                    title: 'flashpoint', favorite: false
                  }
                ]
    }
]

Nicolas Ducom · Accepted Answer · 2017-09-23 22:02:48Z

2

You're actually hitting one of the limitations of MongoDB, a Ticket on their Jira was opened in 2010 regarding updating items in deeply nested arrays, and has just been implemented, stated for release with Mongo 3.5.12. If you're using an older version, the simplest solution would be to go for a second collection containing your articles (with references on the first collection), so you can update them directly.

answered Sep 23, 2017 at 22:02

Nicolas Ducom

2482 silver badges13 bronze badges

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

2 Comments

slmartin Over a year ago

Awesome Nicolas, thanks a lot for the answer and pointing me in the right direction!

Nicolas Ducom Over a year ago

My pleasure, don't hesitate to Accept my answer if it answers your question, the mods will thank you :)

Collectives™ on Stack Overflow

Updating a deeply nested object in mongodb

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related