How to pass a var in an mongodb query in node js

Question

I want to pass a variable to the query, but I didn't find out how:

 db.collection('users').update(
  { "_id":ObjectID(req.params.id)},
  { $set:  { tasks[req.params.pos].done : true }}
  ,(error,resultat)=>{
       if (resultat){
         console.log("mise a jour avec succes ");
         res.send({message:"mise a jour avec succes "});
       } else {
         console.log("Erreur lors du mise a jour ");
         res.send({message:"Erreur lors du mise a jour "});
       }  

     });

and this is the mongodob document I want to change the field done but with the index from a variable like : var x = 5 " task[x].done = true "

{
"_id" : ObjectId("5a730e55114dbc2a0455c630"),
"email" : "[email protected]",
"password" : "unknown",
"tasks" : [ 
    {
        "title" : "new 5",
        "description" : "dod ododoododododo",
        "date" : "2018-02-07T18:25:14.881Z",
        "done" : false
    }, 
    {
        "title" : "new2",
        "description" : "dod ododoododododo",
        "date" : "2018-02-07T18:25:14.881Z",
        "done" : false
    }
]
}

Unexpected token + ///___ Can't made a concatination in the $set — Hassen Fadhlaoui
– Hassen Fadhlaoui, Commented Feb 11, 2018 at 13:02
let q = { 'tasks.' + req.params.pos + '.done': true} and then $set: q — Nilesh Singh
– Nilesh Singh, Commented Feb 11, 2018 at 13:05

sharkdawg · Accepted Answer · 2018-02-11 15:06:19Z

1

From the Mongo docs you need to use the positional $ operator

    db.collection('users')
    .update({'tasks.title': 'new2'}, 
    {'$set': {'tasks.$.done': false}},
    (error,resultat)=>{...

edited Feb 11, 2018 at 15:06

answered Feb 11, 2018 at 13:09

sharkdawg

9841 gold badge8 silver badges20 bronze badges

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

7 Comments

Hassen Fadhlaoui Over a year ago

Still the same problem SyntaxError: Unexpected token +

Hassen Fadhlaoui Over a year ago

The problem that if I do like this _____db.collection('users').update( { "_id":ObjectID(req.params.id)}, { $set: { tasks.0.done : true }}_______ it works fine

Hassen Fadhlaoui Over a year ago

Look in answers i upload a picture to you

sharkdawg Over a year ago

I've updated my answer to use the positional $ operator

Paul Over a year ago

This is the correct answer, per the docs. Note that as this answer demonstrates, you must include the array field as part of the query.

|

Hassen Fadhlaoui · Accepted Answer · 2018-02-12 14:55:53Z

0

Here is the solution Thank You all for contributing in solving this problem

connection((db)=>{

let tid = { ["tasks."+req.params.pos+".done"] : true };

let query = { "_id": ObjectID(req.params.id) };

db.collection('users').update(
  { "_id":ObjectID(req.params.id)},
  { $set:    tid}
  ,(error,resultat)=>{
       if (resultat){
         console.log("mise a jour avec succes ");
         res.send({message:"mise a jour avec succes "});
       } else {
         console.log("Erreur lors du mise a jour ");
         res.send({message:"Erreur lors du mise a jour "});
       }  

     });
})

answered Feb 12, 2018 at 14:55

Hassen Fadhlaoui

1971 silver badge13 bronze badges

Collectives™ on Stack Overflow

How to pass a var in an mongodb query in node js

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related