Filtering with an array of objects Regex in mongodb and mongoose

Question

I'm trying to create a dynamic filter that can be implemented using at least 3 letters. I've got a lot of fields which i will be filtering against.

As an example, If I am trying to find users by email, I want to be able to type "@gma" or at least "gma" and ideally, it should return an array of all users containing the specified filtering value. This should be the same when searching for properties like firstName and so on

My current solution only works if I provide a full value that matches what I already have in my database. e.g [email protected] for email or john for firstName. I want to be able to type jo for the latter.

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

Do you want the key value to be dynamic too? The user gives you the key and value to regex and you create the query? — J.F.
– J.F., Commented Oct 20, 2021 at 12:03

J.F. · Accepted Answer · 2021-10-20 12:15:55Z

2

If I've understood correctly, since you are using JS you can create the find object like this:

let findObj = {}
findObj[userKey] = {$regex:userFilter, $options:"i"}
const filteredU = UserModel.find(findObj)

This creates que object like this:

const userFilter = "gma"
const userKey = "email"
let findObj = {}
findObj[userKey] = {$regex:userFilter,$options:"i"}
console.log(findObj)

What is the same that in this query

answered Oct 20, 2021 at 12:15

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

1 Comment

Mhd Over a year ago

Thanks mate. this should do

Collectives™ on Stack Overflow

Filtering with an array of objects Regex in mongodb and mongoose

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related