MongoDB: querying using a string reference as a key

Question

Does anyone know if there's a way to use a reference to a string in a mongo query, instead of using the string directly in it?

i.e. I want to do this:

key = "id";
value = "12345";
collection("accounts").find({key: value});

Instead of this:

collection("accounts").find({"id": "12345"});

I specifically want to know how to do this for the primary key - i.e. collection("accounts").find({"_id": ObjectId("12345")}); — user2521119
– user2521119, Commented Nov 19, 2016 at 17:46
Possible duplicate of Can I use '$set' on embedded document when use variable as filed name in MongoDB? — Sede
– Sede, Commented Nov 19, 2016 at 18:49

chridam · Accepted Answer · 2016-11-19 17:55:05Z

1

Use the bracket notation to create the query object:

key = "_id";
value = "57ffe131b0b79719a0db75d8";
query = {};
query[key] = ObjectId(value);
collection("accounts").find(query);

answered Nov 19, 2016 at 17:55

chridam

104k26 gold badges246 silver badges243 bronze badges

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

1 Answer 1