Update nested array field inside another array in a mongo db document

Question

I'm just wondering how I can update a nested array field inside a mongo db document.

Here is how my schema looks like:

const userSchema = new Schema({
  email: {type: String, unique: true, lowercase: true},
  password: String,
  firstName: String,
  lastName : String,
  role: String,
  children: Array
});

This is how the document looks like:

{
"_id" : ObjectId("5b3570f3150a0b57a4e7421e"),
"children" : [ 
    {
        "fullName" : "John doe",
        "yearGroup" : "4",
        "absences" : [],
        "id" : "765"
    }
],
"email" : "[email protected]",
"firstName" : "John",
"lastName" : "Doe",
"role" : "parent",
"__v" : 1

}

Where I want to push a new object into to 'absences' array.

0.sh · Accepted Answer · 2018-06-29 02:08:17Z

1

to do this you have to use the mongodb $push operator via the update operation, which i guess that is what you want to do, but you did not specify your match query. To push to absences do this ( i assume the match query is children.fullName )

db.ops.update( { "children.fullName": "John doe" } , { $push: { "children.$.absences": "data to push" } } );

the $ placeholder tells mongodb to replace it self ( i.e $ ) with the matched array index.

incase you want to prevent duplicate elements in absences field you have to use the $addToSet operator

db.ops.update( { "children.fullName": "John doe" } , { $addToSet: { "children.$.absences": "data to push" } } );

answered Jun 29, 2018 at 2:08

0.sh

2,80222 silver badges40 bronze badges

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

1 Comment

Abdi Over a year ago

I get an error ''cannot use the part (children of children.id) to traverse the element'

Collectives™ on Stack Overflow

Update nested array field inside another array in a mongo db document

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related