Mongodb Query does not work with string

Question

I am trying to get documents in the database that match the string but it does not work when i pass in the variable.

I have a string serviceString and serviceString = "test1", "test2", "test3"

        query = db.collection('Services').find({
            'Service': {
                $in: [serviceString]
            }
        });

This returns nothing from the DB BUT if I do this:

        query = db.collection('Services').find({
            'Service': {
                $in: ["test1", "test2", "test3"]
            }
        });

It works and returns what I need.

Do you know why its not working, I am thinking the string is putting commas in as a string. Whats a way I can do this because the string is a input from a user so it can change so I cant hard code the variables in the query?

Try this query = db.collection('Services').find({ 'Service': { $in: serviceString.split(',') } }); — chridam
– chridam, Commented Nov 17, 2016 at 13:55

Natsathorn · Accepted Answer · 2016-11-17 14:04:59Z

1

$in is looking up for an array.

So, It's better to create an array of string you want to find.

let serviceString = ["test1", "test2", "test3"];

Note : You can also use var instead of let here

Then your query will look likes :

let serviceString = ["test1", "test2", "test3"];
query = db.collection('Services').find({
       'Service': {
           $in: serviceString
      }
});

more information : https://mongodb.github.io/node-mongodb-native/markdown-docs/queries.html#special-query-operators

edited Nov 17, 2016 at 14:04

answered Nov 17, 2016 at 13:52

Natsathorn

1,5281 gold badge13 silver badges27 bronze badges

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

Comments

Parshuram Kalvikatte · Accepted Answer · 2016-11-17 13:52:33Z

0

You need to know what are you doing first you are passing a complete string

"test1","test2","test3"

Do something like this

var serviceString = ["test1","test2","test3"];

and then your query

   query = db.collection('Services').find({
            'Service': {
                $in: serviceString
            }
        });

answered Nov 17, 2016 at 13:52

Parshuram Kalvikatte

1,6465 gold badges23 silver badges45 bronze badges

Collectives™ on Stack Overflow

Mongodb Query does not work with string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related