Update Value in nested array using moogoose

Question

How can I update nested arrays value using express and mongoose, a multi-dimensional array, and need to update a single object keys value? Here is my data model

    {
    "_id":'A'
    "media" : {
            "pictures" : [ 
                {
                    "_id" : 'B',
                    "file_name" : "Uploads\\1625311512442-1_PiHoomzwh9Plr9_GA26JcA.png",
                    "status" : false
                }, 
                {
                    "_id" : 'C',
                    "file_name" : "Uploads\\1625311520688-images.jpg",
                    "status" : false
                }, 
                {
                    "_id" : 'D',
                    "file_name" : "Uploads\\1625311696037-1_PiHoomzwh9Plr9_GA26JcA.png",
                    "status" : false
                }, 
               
            ]
        }
    }

 {
    "_id:"'B'
    "media" : {
            "pictures" : [ 
                {
                    "_id" : 'M',
                    "file_name" : "Uploads\\1625311512442-1_PiHoomzwh9Plr9_GA26JcA.png",
                    "status" : false
                }, 
              
            ]
        }
    }

Here I want to change the status of the file based on the id and image id. A is the id b is the image id

Arvind Pal · Accepted Answer · 2021-07-03 13:42:50Z

1

You can use following query to update the data as your requirement

Users.updateOne(
      {
        _id:"A"
      },
      {
        $set:{
          "media.pictures.$[el].status":true
        }
      },
      {
        arrayFilters:[{
          "el._id":"B"
        }]
      }
    )

I also tried to execute the query in mongoDB, Here is result screenshot

edited Jul 3, 2021 at 13:42

answered Jul 3, 2021 at 13:32

Arvind Pal

5213 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Update Value in nested array using moogoose

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