mongo db update subdocument - subdocument not in array

Question

I have a document like this,

{
    "S" : {
        "500209" : {
            "total_income" : 38982,
            "interest_income" : 1714,
            "reported_eps" : 158.76,
            "year" : 201303
        }
    },
    "_id" : "pl"
}

I am trying to update this document like this,

{
    "S" : {
        "500209" : {
            "total_income" : 38982,
            "interest_income" : 1714,
            "reported_eps" : 158.76,
            "year" : 201303,
            "yield": 1001,  <== inserted a new attribute
        }
    },
    "_id" : "pl"
}

I have tried this,

db.my_collection.update({_id: 'pl'},{$set: {'S.500209.yield': 1}})

But I couldn't make it. And I searched in stack overflow and google but I couldn't find out.

I got so many answers but most of them keeping sub-docuemnts in array.

Pleas help me to solve my issue, and please tell me why most of them keeping subdocuments in array.

Mustafa Genç · Accepted Answer · 2013-10-24 08:11:32Z

1

Number key might cause the problem. Update your field name.

db.my_collection.update({_id: 'pl'},{$set: {'S.a500209.yield': 1}})

EDIT

Upgrade mongo version. It works fine with 2.4.

edited Oct 24, 2013 at 8:11

answered Oct 24, 2013 at 7:07

Mustafa Genç

2,58920 silver badges36 bronze badges

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

4 Comments

John Prawyn Over a year ago

you are exactly correct. The problem is because of number. I have changed that number to a string and tried. It is working.

Mustafa Genç Over a year ago

As I guess :) But the problem is definetely about numeric field name. S.500209 means that S is an array and I want 500209th element. Can you just add a prefix to your "500209" key and make it something like "a500209"? 'S.a500209.yield' would work, I think. If any solution without changing the field name is available, someone would enlighten us

John Prawyn Over a year ago

I need a solution without changing field name :-) its hard for me to change field name.

John Prawyn Over a year ago

I am using 2.2. Will upgrade it now ! Thanks a lot.

Collectives™ on Stack Overflow

mongo db update subdocument - subdocument not in array

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related