NodeJS Mongoose wont accept string variable in $regex

Question

I got one record with admin.name = "FooBar" And I want to do a findOne on the name but case insensitive.

In Studio3T this works fine...

db.admin.findOne(
     { name: { $regex: /^FoObAr/i } }
)

But in nodeJS I cant seem to get a variable containing the regexp into the find statement...

Let ID = "FoObAr"
return resolve( adminModel.findOne( { "name" : { $regex: "/^" + ID + "$/i"} } ) );

This one results in... (which gives 0 results)

Mongoose: admin.findOne({ name: { '$regex': '/^FoObAr$/i' } }, { projection: {} })

I also tried

Let ID = "FoObAr"
return resolve( adminModel.findOne( { "name" : { $regex: /^ ID $/i } ) );

This one results in... (which gives 0 results)

Mongoose: admin.findOne({ name: { { $regex: /^ ID $/i } }, { projection: {} })

Any ideas?

Mahesh Bhatnagar · Accepted Answer · 2019-12-10 12:34:37Z

1

Please use RegExp function

admin.find({name:new RegExp(['^',ID, '$'].join(''), 'i')}).projection({})

answered Dec 10, 2019 at 12:34

Mahesh Bhatnagar

1,0801 gold badge8 silver badges8 bronze badges

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

1 Comment

torbenrudgaard Over a year ago

Executed it perfectly... collection.js:204 Mongoose: admin.findOne({ name: /^FoObAr$/i }, { projection: {} })

Rashad Ibrahimov · Accepted Answer · 2019-12-10 20:30:40Z

1

You should pass RegExp object, not string.

adminModel.findOne({ "name" : { $regex: new RegExp(/^FoObAr/, 'i') } })

With variable ID it will look like

adminModel.findOne({ "name" : { $regex: new RegExp(`^${ID}$`, 'i') } })

edited Dec 10, 2019 at 20:30

answered Dec 10, 2019 at 12:41

Rashad Ibrahimov

3,3193 gold badges21 silver badges41 bronze badges

1 Comment

torbenrudgaard Over a year ago

Dosnt show me how to put the ID variable inside, so I once again end up like this.. { "name" : { $regex: new RegExp("/^" + ID + "/", 'i') } which does not work

Collectives™ on Stack Overflow

NodeJS Mongoose wont accept string variable in $regex

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related