How to use variable mongoose query?

Question

data schema

ID: String,    
Item: {
       Possess: {
          Jewel: [Number]
     }

code

var temp = 1
db.collection.update({"ID":"sample"},{"$set":{"Item.Possess.Jewel.1":888})

How to use variable temp in "Item.Possess.Jewel.1" ?

"Item.Possess.Jewel.temp" doesn't work

JohnnyHK · Accepted Answer · 2014-02-06 04:10:38Z

5

You have to build up your $set object programmatically:

var temp = 1;
var set = {$set: {}};
set.$set["Item.Possess.Jewel." + temp] = 888;
db.collection.update({"ID":"sample"}, set);

answered Feb 6, 2014 at 2:34

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

1 Answer 1