Regex for Mongo db from node.js is not working

Question

I am using regex to fetch data from mongodb from my node js application which is not working. Here is the code snippet. the query can not match with the set of records.

var analysis_date = '/^'+moment(fromTime).format('YYYY-MM').toString()+'/';
user_analysis.find({
parent_id: usrId,
analysis_date: { 
    $regex : analysis_date 
   }
},function(err, result) {
//some Code goes here});

Did you manage to solve the problem?

Dmytro Shevchenko
– Dmytro Shevchenko

2017-03-20 07:44:00 +00:00
Commented Mar 20, 2017 at 7:44 — Dmytro Shevchenko
– Dmytro Shevchenko, Commented Mar 20, 2017 at 7:44
Yes it worked with the second way you mentioned.

Angshuman
– Angshuman

2017-03-20 19:45:32 +00:00
Commented Mar 20, 2017 at 19:45 — Angshuman
– Angshuman, Commented Mar 20, 2017 at 19:45

Dmytro Shevchenko · Accepted Answer · 2016-12-14 14:22:41Z

3

Instead of specifying the regular expression as a string, try passing a RegExp object:

user_analysis.find({
    "parent_id": usrId,
    "analysis_date": new RegExp(analysis_date, 'i')
}, function(err, result) {
    // ...
});

If you want, you can also pass a string, but then you'll need to remove the / delimiters:

user_analysis.find({
    "parent_id": usrId,
    "analysis_date": {
        $regex: '^' + moment(fromTime).format('YYYY-MM').toString(),
        $options: "i"
    }
}, function(err, result) {
    // ...
});

answered Dec 14, 2016 at 14:22

Dmytro Shevchenko

34.9k6 gold badges56 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Regex for Mongo db from node.js is not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related