How to Query Mongoose db in express.js with "like" command /"string"/l?

Question

I am querying Mongoose db with a search, where the title is the "customTitle" from the URL.

The search works well if I search for all items, e.g. Article.find(err, foundArticles) =>, but I am getting an empty query response to Article.find({title:/customTitle/i}, (err, foundArticles) => {

I'd like to get a response with all items, that contains "customTitle" variable in any record.

app.route("/:customTitle")
.get(function(req, res){
  const customTitle = _.capitalize(req.params.customTitle);
  Article.find({title:/customTitle/i}, (err, foundArticles) => {
  if (!err){
    res.send(foundArticles);
    console.log(typeof customTitle +" ", customTitle);
    console.log(foundArticles);
  } else {
    res.send(err);
  }
});

What is the problem here, please? Thank you.

Steven Spungin · Accepted Answer · 2022-10-03 05:02:12Z

1

You need to create the regex using new RegExp. You are searching for the literal string customTitle.

For example:

const rx = new RegExp(customTitle, 'i')
query.find({title:rx})

answered Oct 3, 2022 at 5:02

Steven Spungin

29.5k7 gold badges97 silver badges85 bronze badges

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

4 Comments

DeLucasso Over a year ago

Could you please check what else is wrong there? I'm getting still empty response. Thank you

Steven Spungin Over a year ago

You might have characters that need escaping. Post your error.

Steven Spungin Over a year ago

Also, hardcode a simple string in the regex instead of using input from query, and see if it works.

DeLucasso Over a year ago

Ok, both work now, so I edited the answer, and I leave it here for others. Thanks!

DeLucasso · Accepted Answer · 2022-10-03 05:52:15Z

I've found, that I can use RegExp of Mongoose and JavaScript

Mongoose RegExp that works:

app.route("/:customTitle")
  .get(function(req, res) {
    const customTitle = _.capitalize(req.params.customTitle);
    Article.find({ title: {$regex: customTitle, $options:'i'}}, (err, foundArticles) => {
      if (!err) {
        res.send(foundArticles);
      } else {
        res.send(err);
      }
  });

And JavaScript RegExp that works:

  app.route("/:customTitle")
    .get(function(req, res) {
      const customTitle = _.capitalize(req.params.customTitle);
      const rx = new RegExp(customTitle, 'i');
      Article.find({title:rx}, (err, foundArticles) => {
        if (!err) {
          res.send(foundArticles);
        } else {
          res.send(err);
        }
    });

Collectives™ on Stack Overflow

How to Query Mongoose db in express.js with "like" command /"string"/l?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related