MongoDB query on a field with integer value

Question

I'm trying to do a find query using a string and a number as fields. The query works while looking for the string alone. How can I make it work for number as well?

var check = request.body.cookie; // String
var tok = request.body.token; // It's a number

db.collection("users").find({'name':check, 'token':tok}).toArray(function(err, rows) {
    if(!rows.length)    
    {
    console.log("No data found");
    }
});

A sample collection is given below

> db.users.find()
{ "_id" : ObjectId("608be0dc8b83df0248ed2fc1"), "name" : "John", "age" : "18", "gender" : "M", 
"country" : "RR", "socketid" : "1",
"token" : "5907" }

What do you get when you try console.log(typeof request.body.token); — prasad_
– prasad_, Commented Apr 30, 2021 at 14:00
I deleted accidentially a curly bracket after the if statement - unforunately the edit queue is full... — biberman
– biberman, Commented Apr 30, 2021 at 17:14

turivishal · Accepted Answer · 2021-04-30 14:05:08Z

2

You can use expression $expr condition to make sure hundred percent whatever token has type string or number,

$toInt to convert string to number

var check = request.body.cookie; // String
var tok = request.body.token; // It's a number

db.collection("users").find({
  $and: [
    { name: check },
    {
      $expr: {
        $eq: [{ $toInt: "$token" }, tok]
      }
    }
  ]
}).toArray(function(err, rows) {
    if(!rows.length)    
        console.log("No data found");
    }
});

Playground

answered Apr 30, 2021 at 14:05

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Comments

turivishal · Accepted Answer · 2021-04-30 14:27:22Z

2

The token field is probably stored as a string in the database, not as a number. Look at the commas.

"token" : "5907"

Try converting tok to a string in the query.

find({'name':check, 'token':String(tok)})

edited Apr 30, 2021 at 14:27

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

answered Apr 30, 2021 at 14:01

sofa_maniac

1,6873 gold badges12 silver badges22 bronze badges

1 Comment

Black Heart Over a year ago

This works as well. A simple fix!! Thanks!!

Collectives™ on Stack Overflow

MongoDB query on a field with integer value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related