how do i push element in double nested array MongoDb?

Question

how to i push value in double nested array as shown in below code !!

    {
        "_id" : ObjectId("627ce38702f566ef8e89977a"),
        "name" : "max",
        "sub" : {
                "type" : "maths",
                "grades" : [
                        {
                                "semOne" : [
                                        7,
                                        8,
                                        9
                                ]
                        },
                        {
                                "semTwo" : [
                                        9,
                                        11,
                                        12
                                ]
                        }
                        
                    ]
            }
    }

let say i want to add 13 in semOne, how do i add ??

ray · Accepted Answer · 2022-05-12 12:51:13Z

2

You can use $push in update with arrayFilters.

db.collection.update({
  "_id": ObjectId("627ce38702f566ef8e89977a")
},
{
  $push: {
    "sub.grades.$[g].semOne": 13
  }
},
{
  arrayFilters: [
    {
      "g.semOne": {
        $exists: true
      }
    }
  ],
  multi: true
})

Here is the Mongo playground for your reference.

edited May 12, 2022 at 12:51

answered May 12, 2022 at 12:29

ray

15.6k12 gold badges96 silver badges104 bronze badges

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

Comments

Atul Yadav · Accepted Answer · 2022-05-12 11:53:55Z

1

Probably like this:

const object = {
    "_id" : ObjectId("627ce38702f566ef8e89977a"),
    "name" : "max",
    "sub" : {
            "type" : "maths",
            "grades" : [
                    {
                            "semOne" : [
                                    7,
                                    8,
                                    9
                            ]
                    },
                    {
                            "semTwo" : [
                                    9,
                                    11,
                                    12
                            ]
                    }
                    
                ]
        }
}

Try this:

object.sub.grades[0].semOne.push(13)

You might have facing error that .push is not a function, because "grades" is an array and here you have to define object position to push something.

answered May 12, 2022 at 11:53

Atul Yadav

712 silver badges8 bronze badges

1 Comment

sunilsalat Over a year ago

hi atul, is ther any other way using $push , asking out of curiosity !!

Collectives™ on Stack Overflow

how do i push element in double nested array MongoDb?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related