Search query string from array list of string of different objects in mongodb

Question

I want to search a query string against the array of string stored in array of all the objects presents

my database structure looks like this

[0: 
     destination: ......
     name: ......
     name_list: [""some place", "some place 2", "some place3"]
1:
    destination: ......
    name: ......
    name_list: [""some place4", "some place 5", "some place3"]
2:
    destination: ......
    name: ......
    name_list: [""some place56", "some place 34", "some place3"]

and so on .... 
]

let's say

I want to get all the objects whose name_list array contains string "someplace3" but the query i will receive might only be "place3", since user might not know the complete or exact name. I can't figure how to search, I'am using expressjs module to search in my mongodb database like:

route.find({name_list: "place3"}, function(err, routes) {
    if (err) throw err;
    routeTosend = routes;
});

but obviously I am not getting any results, but if i search exactly like someplace3 it returns all the objects.

I am completely new to database hence mongodb as well, if anyone can help would really appreciate.

node_saini · Accepted Answer · 2017-03-03 06:22:57Z

1

You have to make use of $regex provided by mongodb. You can do something like this

route.find({"name_list": {$regex : /.*places3.*/}}, function(err, routes) {
   if (err) throw err;
   routeTosend = routes;
});

To use variable inside regex you have to create regex object from a string using RegExp constructor

var query= "place"; 
regx = new RegExp('.*' + query + '.*','i');

route.find({"name_list": regx}, function(err, routes) {
   if (err) throw err;
   routeTosend = routes;
});

edited Mar 3, 2017 at 6:22

answered Mar 2, 2017 at 12:10

node_saini

8321 gold badge10 silver badges24 bronze badges

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

5 Comments

warl0ck Over a year ago

thanks for the help, worked perfectly, but can i pass variables as well, inside regex expression ?

node_saini Over a year ago

to use variable inside regex you have to create regex object from a string using RegExp constructor something like this {"name_list" : new RegExp(your_reg_variable)}

warl0ck Over a year ago

something like, var myquery = "place"; {"name_list" : new RegExp(myquery )} but it's not working can you please help me out here.

node_saini Over a year ago

try to concatenate pattern either in myquery variable or inside constructor

warl0ck Over a year ago

yep, got it, with ` var query= "place"; regx = new RegExp('.*' + variable + '.*','i');`, thanks for the help, can you please update the answer with this as well.

Collectives™ on Stack Overflow

Search query string from array list of string of different objects in mongodb

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related