mongodb - How to perform a search on selected fields in mongoose

Question

Say I have User schema with three fields, a username, email, and password, how would I do a query with mongoose in which I search the username and email fields only and return matched documents.

For example in expressjs the URL would be:

http://localhost:8000/users/search?q=testuser

Posting to that ur should return an array of documents that have testuser either in its email, username, or both.

question from:https://stackoverflow.com/questions/65852440/how-to-perform-a-search-on-selected-fields-in-mongoose

Answer 1

Is as simple as pass the values into find() method with an $or condition.

Check this example:

db.collection.find({
  "$or": [
    {
      "username": {
        "$regex": "testuser"
      }
    },
    {
      "email": {
        "$regex": "testuser"
      }
    }
  ]
})

Return the values where username or email contains testuser.

With mongoose you can use the saeme:

yourModel.find({
            "$or": [
               { "username": { "$regex":"testuser" } },
               {"email": { "$regex":"testuser" } }
             ]
        }).then(result => {
            console.log(result);
        }).catch(e => {
            console.log(e);
        })