CODEWITHSUNDEEP
node.jsmongodbmongoose
Janith Widarshana
Janith Widarshana

Reputation: 3483

mongoose find() document with two fields with one search parameter

My node model contains following properties 

firstName
lastName
age
address

I need to use mongoose find functions to filter user with firstName and lastName.

My UI pass only one search parameter. Data should filter as follows

'fistName' like 'search parameter' & lastName like 'search Parameter'.

I pass following object to find function.It did not work for me. 

var criteria = {
    'firstName' : req.body.customerName ? { $regex: req.body.customerName, $options: 'i' } : null ,
    'lastName' : req.body.customerName ? { $regex: req.body.customerName, $options: 'i' } : null 
};

Upvotes: 5

Views: 14819

Answers (4)

Shaishab Roy
Shaishab Roy

Reputation: 16805

If you want to get data if match with both fields of firstName and lastName then you can use $and operator with $regex.

var query = {$and:[{firstName:{$regex: req.body.customerName, $options: 'i'}},{lastName:{$regex: req.body.customerName, $options: 'i'}}]}

and If you want to get data if match with any one field of firstName and lastName then you can use $or operator with $regex.

var query = {$or:[{firstName:{$regex: req.body.customerName, $options: 'i'}},{lastName:{$regex: req.body.customerName, $options: 'i'}}]}

so can try this code:

var query = {}
if(req.body.customerName) {
  query = {$or:[{firstName:{$regex: req.body.customerName, $options: 'i'}},{lastName:{$regex: req.body.customerName, $options: 'i'}}]}
}

ModelName.find(query , function (err, data) {
   if(error) {
     // return error
   }
   //return data
});

Upvotes: 20

Paul
Paul

Reputation: 36319

So, I think you have a logical flaw in addition to a syntactic flaw. Unless you're intentionally looking only for people who have the same first name and last name (e.g. Tom Tom), then you'll never find anyone by simply finding on both fields with the same value in each. If, as I suspect, you really want to take a search criteria and see if a user has that string in either their first name or last name, then you'll actually want to use $or.

Something like:

let query = {};
if(req.body.customerName){
   const nameExp = new RegExp('^'+req.body.customerName+'$', 'i');
   query = { $or : [ { firstName: nameExp }, { lastName: nameExp } ] }; 
}

MyModel.find(query, (err, data) => { /* do your thing */ });

Upvotes: 2

digit
digit

Reputation: 4565

You can try pass the following criteria

var criteria = {
    'firstName' : req.body.customerName ? {$regex: req.body.customerName + '.*', $options: 'i'} : null ,
    'lastName' : req.body.customerName ? {$regex: req.body.customerName + '.*', $options: 'i'} : null 
};

Upvotes: 0

Gaurav joshi
Gaurav joshi

Reputation: 1799

var query = {}
if(req.body.customerName) {
     query  = {
              firstName :new RegExp('^'+req.body.customerName+'$', "i"),
              lastName : new RegExp('^'+req.body.customerName+'$', "i")
          }
}
 MyModel.find(query , function (err, data) {
   // data.forEach 
});

Upvotes: 0

Related Questions