Node.js and Mongoose regex query on multiple fields


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(, 'i');

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

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

7/30/2012 4:33:52 PM

Accepted Answer

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

7/30/2012 4:55:18 PM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow