How to update a field value in array in mongo database?

Question

How can we update a value for 'Enabled' field in Configuration at index 1 in Configurations Array in mongo database ?

Below is my Json data.

{
    "Configurations" : [ 
                           {
                               "Configuration" : {
                                   "Host" : "",
                                   "Port" : "1521",
                                   "Enabled" : "true"                 
                               }
                            }, 
                            {
                               "Configuration" : {
                               "Host" : "",
                               "Port" : "",
                               "Enabled" : "true"
                               }                                  
                            }
                        ],
    "Description" : "Check Database Server"                   
}

Is there any way to update value for Enabled field in Configuration ?? How can we update a value for 'Enabled' field in Configuration at index 1 in Configurations Array in Mongodba ?

I want to update Enabled field value of 2nd configuration in Configurations Array.

possible duplicate of How to Delete an element from the array which is present inside an object in Mongodb/mongoose — Neo-coder
– Neo-coder, Commented Apr 23, 2015 at 7:11
Array indices tend to be based on 0. And this reminds me of a MongoU question... — Markus W Mahlberg
– Markus W Mahlberg, Commented Apr 23, 2015 at 13:38

Sede · Accepted Answer · 2015-04-23 07:04:57Z

2

What about something like this

db.collection.update({}, 
    { "$set": { "Configurations.1.Configuration.Enabled": false }}
)

answered Apr 23, 2015 at 7:04

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

1 Comment

Anuj Verma Over a year ago

Yes, I want something like this but what value we should pass for ... in the below code. db.collection.update( ''....'', { "$set": { "Configurations.1.Configuration.Enabled": false }} )

Vishwas · Accepted Answer · 2015-04-23 07:17:42Z

0

Try this:

db.collection.update({
"Configurations": {
    "$elemMatch": {
        "Configuration.Port": "1521"
    }
}
}, {
"$set": {
    "Configurations.$.Configuration.Enabled": "false"
}
})

answered Apr 23, 2015 at 7:17

Vishwas

7,0777 gold badges46 silver badges70 bronze badges

Collectives™ on Stack Overflow

How to update a field value in array in mongo database?

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related