How to use variables in MongoDB query?

Question

Is it possible to use a variables in MongoDB's query like this?

var FOO="123";
var BOO="323";
user.findOneAndUpdate({_id: userID},{$set:{FOO:BOO}}

BOO - the value, is working fine and it's being assign, while FOO - the key is not.

No, in MongoDB Foo is not a variable but a key "FOO" not FOO — Manjeet Singh
– Manjeet Singh, Commented Jan 7, 2018 at 11:28

Manjeet Singh · Accepted Answer · 2018-01-07 11:41:50Z

5

In MongoDB as such no functionality but you can do this in javascript like this

    var FOO="123";
    var BOO="323";
    user.findOneAndUpdate({_id: userID},{$set:{[FOO]:BOO}}

answered Jan 7, 2018 at 11:41

Manjeet Singh

2,4061 gold badge18 silver badges39 bronze badges

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

4 Comments

Thanks for your answer, could you explain why this syntax actually works?

@AndriySimonov you can read here

@ManjeetThakur Thanks - PhpStorm doesn't recognize this syntax...but the code is running ..

@RoyBarOn Please accept the answer if this is working for you