Can I use '$set' on embedded document when use variable as filed name in MongoDB?

Question

I want to use '$set' to update an embedded document, but the field is a variable.

Say I have a document like:

{'_id': ObjectID,
 'people': {
     'A': {'age': 20}
 }
}

Now I want to add a new person to people. I can use $set: {'people.B':{'age': 25}, but what if the name(instead B) is a variable?

I am using Node.js 5.1 and 'mongodb' driver.

It sounds like people should be an array. Is there a reason why you are explicitly labeling the objects 'A', 'B', etc.? — Thomas Stringer
– Thomas Stringer, Commented Nov 30, 2015 at 14:16

Sede · Accepted Answer · 2015-11-30 14:20:27Z

1

You need to build your query dynamically using the [] operator.

var b = 'B';
var update = {};
update['people.' + b] = { 'age': 25 };
db.collection.update({}, { '$set': update })

answered Nov 30, 2015 at 14:20

Sede

61.5k20 gold badges159 silver badges162 bronze badges

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

1 Answer 1