Find and update of object in nested array

Question

I have this mongoose schema

{
    id: mongoose.Schema.Types.ObjectId,
    name: String,
    initialMailSended: Boolean,
    email: String,
    users: [{
        id: mongoose.Schema.Types.ObjectId,
        name: String,
        surname: String,
        email: String,
        signedUp: Boolean,
        company: String,
        email: String,
        attending: String,
        accomod: String,
        program: String,
        food: String,
        other: String,
        allFood: String,
        form: [{
            name: String,
            value: String,
        }]
    }]
}

What i need to do is write a mongoose query which find this object by id and in this object find user and update it. I tried various queries but didn't find any which would work.

Possible duplicate of MongoDB: How do I update a single subelement in an array, referenced by the index within the array? — Ashh
– Ashh, Commented Apr 13, 2019 at 8:00

konuralpt · Accepted Answer · 2019-04-13 08:42:10Z

1

For your question, you can update your user like this

db.getCollection('collection').findOneAndUpdate(
    {
      _id:ObjectId("5cb19dbc85fdcb7868400107"),       // collection id
     'users._id':ObjectId("5cb19dbc85fdcb7868400185") // user id inside collection
    },

    {$set: {'users.$.name': 'new value'}}            // set name field
)

also see this question Updating a Nested Array with MongoDB

answered Apr 13, 2019 at 8:42

konuralpt

2712 silver badges12 bronze badges

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

2 Comments

Jiří Rejman Over a year ago

Actions.find({             _id: actionId,             'users._id': userId          }, (err, data) => {             //console.log(data[0].users);             console.log('data', data);         })

this solution return data with all objects in array

Jiří Rejman Over a year ago

SOLVED - The problem was using fixed value instead of $ in $set part of solution

Collectives™ on Stack Overflow

Find and update of object in nested array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related