Using an array of objects to apply Regex filtering in MongoDB and Mongoose

Question

Using an array of objects to apply Regex filtering in MongoDB and Mongoose

I am working on creating a dynamic filter that can be used with just 3 letters. I have multiple fields that need to be filtered.

For instance, when searching for users by email, I want to be able to type "@gma" or "gma" and get back an array of all users matching the filter value. The same functionality should apply when filtering by properties like firstName.

Currently, my solution only works if I provide an exact match from the database, such as

<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="d3a7b6a0a793b4beb2babffdb0bcbe">[email protected]</a>

for email or "john" for firstName. I want to be able to search for "jo" and still get results for firstName.

const regexPattern = new RegExp(["^", filterUsersByValue, "$"].join(""), "i");
const filteredU = UserModel.find({ [filterUsersBy]: regexPattern})

javascript arrays regex mongodb full-text-search

Answer 1

Answer №1

It seems that using JS allows you to create the find object in a certain way:

let queryObject = {}
queryObject[searchKey] = {$regex:searchTerm, $options:"i"}
const results = DatabaseModel.find(queryObject)

This method generates the following object:

const searchTerm = "abc"
const searchKey = "name"
let queryObject = {}
queryObject[searchKey] = {$regex:searchTerm,$options:"i"}
console.log(queryObject)

This is similar to what is shown in this example query

Answer 2

It seems that using JS allows you to create the find object in a certain way:

let queryObject = {}
queryObject[searchKey] = {$regex:searchTerm, $options:"i"}
const results = DatabaseModel.find(queryObject)

This method generates the following object:

const searchTerm = "abc"
const searchKey = "name"
let queryObject = {}
queryObject[searchKey] = {$regex:searchTerm,$options:"i"}
console.log(queryObject)

This is similar to what is shown in this example query

Using an array of objects to apply Regex filtering in MongoDB and Mongoose

Answer №1

Similar questions

Prevent dropzone from refreshing the page

Remain on the React page following an HTTP POST request to Flask

Image can be centered, but unable to center div in IE7

Display the name of the link on the console

Tips for storing Ajax request information into separate variables

The createReadStream function cannot be found in the uploaded image

The JQuery click handler seems to only be functioning on the initial item

Executing an xajax/ javascript function simultaneously

Using the parseInt method, you can easily combine integers and strings to perform addition and string concatenation simultaneously

Having trouble with AngularJS and NodeJS routing integration?

THREE.js : Chart Your Course in the Digital Realm

Guide to invoking a user-defined server-side function using the MongoDB Node.js driver

Please review the photo libraries for any identical URLs

The Javascript function is being called, yet it cannot be defined

Ways to prevent map object issues in the autocorrelation script

Creating tabs in JavaScript using REST API after div elements have been generated

Guide on retrieving the AWS IAM user in string/json format using STS GetCallerIdentity Caller JS/TS

Configuring relative file paths within the folders in tsconfig.json

Utilizing Node.js to match arrays

Capturing information within a jQuery function by accessing data from another function