MongoDB: Update multidimensional array using their object IDs

Question

I am developing a resume database Web Application using Node.js and MongoDB. I am trying to update a single record located inside a multidimensional array. How do I update a single array from the career_development field bellow given that each array have their own object ID?

{
    "_id": ObjectId("57f35a25983d521a90518efd"),
    "email": "[email protected]",
    "first_name": "John",
    "last_name": "Doe",
    "created_at": ISODate("2016-10-04T07:28:37.407Z"),
    "career_development": [
        {
            "_id": ObjectId("5811aefcb7880316e4497406"),
            "company_name": "TestCompanyName 1",
            "company_location": "Texas, United States"
        },
        {
            "_id": ObjectId("5811afb7b7880316e4497407"),
            "company_name": "TestCompanyName 2",
            "company_location": "South Carolina, United States"
        },
        {
            "_id": ObjectId("5811afbfb7880316e4497408"),
            "company_name": "TestCompanyName 3",
            "company_location": "Florida, United States"
        }
    ]
}

Use the $ positional operator with the dot notation as db.collection.update({ "career_development._id": ObjectId("5811aefcb7880316e4497406") }, { "$set": { "career_development.$.company_name": "TestCompanyName 1 Updated" } }) — chridam
– chridam, Commented Oct 28, 2016 at 11:36
@chridam thanks, that works. but what if say career_development is dynamic? how can I do it something like: var dynamic_variable = posted_data.type; { "$set": { dynamic_variable + ".$.company_name": "TestCompanyName 1 Updated" } } ?? — Carl
– Carl, Commented Oct 28, 2016 at 13:53
No problem. You can create an update object using the bracket notation as var dynamic_variable = posted_data.type; var query = {}; var updateObj = { "$set": { } }; query[dynamic_variable +"._id"] = ObjectId("5811aefcb7880316e4497406"); updateObj["$set"][dynamic_variable +".$.company_name"] = "TestCompanyName 1 Updated"; db.collection.update(query, updateObj) — chridam
– chridam, Commented Oct 28, 2016 at 14:08
@chridam Thanks for the help, it is working perfectly now. Could you please put both your 2 comments in 1 answer so I could mark it as the correct answer? — Carl
– Carl, Commented Oct 28, 2016 at 14:37

chridam · Accepted Answer · 2016-10-28 14:44:25Z

1

Use the $ positional operator with the dot notation as

db.collection.update(
    { "career_development._id": ObjectId("5811aefcb7880316e4497406") }, 
    { 
        "$set": { 
            "career_development.$.company_name": "TestCompanyName 1 Updated" 
        } 
    }
);

If career_development is dynamic, then you can create an update object using the bracket notation as:

var dynamic_variable = posted_data.type,
    query = {},
    updateObj = { "$set": { } }; 

query[dynamic_variable +"._id"] = ObjectId("5811aefcb7880316e4497406"); 
updateObj["$set"][dynamic_variable +".$.company_name"] = "TestCompanyName 1 Updated"; 
db.collection.update(query, updateObj)

answered Oct 28, 2016 at 14:44

chridam

104k26 gold badges246 silver badges243 bronze badges

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

2 Comments

Carl Over a year ago

Thank you for this @chridam

chridam Over a year ago

@Carlo No worries, always happy to help :)

Hemant Manwani · Accepted Answer · 2016-10-28 08:41:56Z

0

Are you saying that the array looks like this? If that is not the case we can user elemMatch to get the doc, loop over it and update it. Let me know, I will post the query over here.

"career_development": [
        {
            "_id": ObjectId("5811aefcb7880316e4497406"),
            "company_name": "TestCompanyName 1",
            "company_location": "Texas, United States"
        },
        {
            "_id": ObjectId("5811afb7b7880316e4497407"),
            "company_name": "TestCompanyName 2",
            "company_location": "South Carolina, United States"
        },
        {
            "_id": ObjectId("5811afbfb7880316e4497408"),
            "company_name": "TestCompanyName 3",
            "company_location": "Florida, United States"
        }
    ],
[
        {
            "_id": ObjectId("5811aefcb7880316e4497406"),
            "company_name": "TestCompanyName 1",
            "company_location": "Texas, United States"
        },
        {
            "_id": ObjectId("5811afb7b7880316e4497407"),
            "company_name": "TestCompanyName 2",
            "company_location": "South Carolina, United States"
        },
        {
            "_id": ObjectId("5811afbfb7880316e4497408"),
            "company_name": "TestCompanyName 3",
            "company_location": "Florida, United States"
        }
    ]

answered Oct 28, 2016 at 8:41

Hemant Manwani

1288 bronze badges

1 Comment

Carl Over a year ago

Not sure what you did there, but I need to update (by object ID) a single record / array inside the career_development field which contains multiple arrays. Can you give me an example?

Collectives™ on Stack Overflow

MongoDB: Update multidimensional array using their object IDs

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related