Updating nested Array data using mongodb

Question

I have nested data:

Object
_id: "90fac6ab-b88e-42a1-8e91-80ee25951ec7"
  answers: Array[4]
    0: Object
      name: "myData"
      owned_by: "273b7291-df2b-494c-bd9b-64e71283447e"
      score: 0

I am trying to update, only a specific nested answer whose name I know. I would simply like to increment the score field, and I only know name. How does one accomplish this?

Thus far I have this: db.Question.update({_id: "90fac6ab-b88e-42a1-8e91-80ee25951ec7"}, "myData":{$inc: {score: 2}});

Sammaye · Accepted Answer · 2012-10-30 08:40:26Z

1

You are looking to increment the score of each answer based on the name of the answerer (I assume that's what name is) as such:

db.Question.update({
    _id: "90fac6ab-b88e-42a1-8e91-80ee25951ec7", 
    answers.name : "myData"
}, {$inc: {"answers.$.score": 1}})

Should work. I use the positional operator here to reach into a suboducment to populate the $: http://www.mongodb.org/display/DOCS/Updating#Updating-The%24positionaloperator

answered Oct 30, 2012 at 8:40

Sammaye

44k7 gold badges110 silver badges149 bronze badges

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

2 Comments

cirrus Over a year ago

Dang! You just beat me to it (poor train wifi).

Giuliano Iacobelli Over a year ago

Is there any way to update the nested queried object using $set and passing an object only containing attributes to be updated? I mean something like this as second arg {$set : {"answers.$" : {attr1:val1, attr2:val2}}}

cirrus · Accepted Answer · 2012-10-30 09:03:19Z

0

Try this;

db.Question.update({ _id: "90fac6ab-b88e-42a1-8e91-80ee25951ec7", "answers.name": "myData" }, 
                   { $inc: { "answers.$.score": 2} });

answered Oct 30, 2012 at 9:03

cirrus

5,6908 gold badges46 silver badges62 bronze badges

Collectives™ on Stack Overflow

Updating nested Array data using mongodb

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related