Unable to update nested array in mongodb using nodeJs, and no error throwing

Question

I need to update nested array in mongodb using nodejs. I have tried like this but not helped and even its not throwing error.

My Collection is this

{
    "country_details": [
    {
        "cities": [
            "Abbeville"
        ],
        "_id": "5a6ec189bb68bb09105eabe8",
        "countryCode": "US",
        "countryName": "United States"
    }
],
    "deletion_indicator": "N",
    "_id": "5a6ec189bb68bb09105eabe7",
    "date_created": "Mon Jan 29 2018 12:09:05 GMT+0530 (India Standard Time)",
    "__v": 0
}

and I want to update cities, And I have try like one

let query = {_id: "5a6ec189bb68bb09105eabe7", countryCode: "US", countryName: "United States"};

countryAndCitiesModel.collection.update(
    query,
    {$push: {"country_details.$.cities": "ABC"}},

    (err, result)=> {
    if(err){
        return next(err);
    }else{
        return next(result);
    }
});

not getting update, but getting result like is

{
    "ok": 1,
    "nModified": 0,
    "n": 0
}

Please help.. Thanks

mickl · Accepted Answer · 2018-01-29 07:17:07Z

2

You're trying to match countryCode and countryName which are properties of nested object country_details and that's why your query can't match any document. To fix that you should fix paths to your fields:

db.collection.update(
    {_id: "5a6ec189bb68bb09105eabe7", "country_details.countryCode": "US", "country_details.countryName": "United States"},
    {$push: {"country_details.$.cities": "ABC"}})

answered Jan 29, 2018 at 7:17

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

3 Comments

Mohammad nabil Over a year ago

Not helped, bro

Mohammad nabil Over a year ago

again same response.

Mohammad nabil Over a year ago

Bro, solved my issue, actually I am directly using the collection instead of whole db, my issue is i am trying like countryAndCitiesModel.collection.update, now i have replaced with countryAndCitiesModel.update,

Collectives™ on Stack Overflow

Unable to update nested array in mongodb using nodeJs, and no error throwing

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related