Node.js and Mongoose regex query on multiple fields

Question

I would like to query multiple fields using the same regular expression for both. In this query, I would like to accept a single text input and check both the firstName and lastName fields for results. I can query a single field just fine using the regex function in the mongoose documentation, but the syntax for an 'or' clause is giving me trouble.

var re = new RegExp(req.params.search, 'i');

app.User.find().or([{ 'firstName': { $regex: re }}, { 'lastName': { $regex: re }}]).sort('title', 1).exec(function(err, users) {
    res.json(JSON.stringify(users));
});

(I'm running mongoose 2.7.1 on node.js 0.6.12)

Syntax looks ok; can you expand on the trouble it's giving you? — JohnnyHK
– JohnnyHK, Commented Jul 30, 2012 at 16:42
Oh darn. It was some bad data. It turns out that does indeed work fine. — RevNoah
– RevNoah, Commented Jul 30, 2012 at 16:54
What if you had a person named "Joe Smith" and and someone searched for "Joe S" - no results? — Mike Causer
– Mike Causer, Commented Mar 22, 2013 at 4:04
@MikeCauser: Any idea how to write search query in case if someone searches for "Joe S" and get records like "Joe Smith" in result. I need to implement it but facing trouble. — Raeesaa
– Raeesaa, Commented May 20, 2014 at 7:56
For a partial match try var re = new RegExp('^.*' + req.params.search + '.*$', 'i'); — Mike Causer
– Mike Causer, Commented May 20, 2014 at 12:52

RevNoah · Accepted Answer · 2012-07-30 16:55:18Z

17

The code above works fine for a query on multiple fields. Turns out I had some bad data.

answered Jul 30, 2012 at 16:55

RevNoah

2,3643 gold badges20 silver badges28 bronze badges

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

Comments

Nolesh · Accepted Answer · 2023-01-08 13:41:32Z

0

My solution is to use $function that allows you to concatenate multiple fields and match their combined value against your regular expression.

const { search } = req.params;
var regex = new RegExp(`.*${search}.*`, 'i');

app.User.find({
    $expr: {
        $function: {
            body: `function(firstName, lastName) { return (firstName+' '+lastName).match(${regex}) }`,                        
            args: ['$firstName', '$lastName'],                
            lang: "js"
        }
    }
})
.exec((err, users) => {
    res.json(JSON.stringify(users));
});

answered Jan 8, 2023 at 13:41

Nolesh

7,05612 gold badges79 silver badges116 bronze badges

Collectives™ on Stack Overflow

Node.js and Mongoose regex query on multiple fields

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related