Querying a Mongoose database in express.js using the "like" command for strings

Question

Querying a Mongoose database in express.js using the "like" command for strings

Currently, I am trying to query my Mongoose database with a search parameter where the title matches the "customTitle" extracted from the URL.

The search function works perfectly fine when searching for all items using

Article.find(err, foundArticles) =>

. However, when attempting to specifically search for records containing the "customTitle" variable using

Article.find({title:/customTitle/i}, (err, foundArticles) => {

, I end up receiving an empty response.

My goal here is to retrieve a response that includes all items containing the "customTitle" variable within any record in the database.

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);
  }
});

If you could help me identify the issue at hand, I would greatly appreciate it. Thank you.

javascript express mongoose

Answer 1

Answer №1

To generate the regular expression, utilize new RegExp. Your objective is to locate the exact string customTitle.

Here's an illustration:

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

Answer 2

To generate the regular expression, utilize new RegExp. Your objective is to locate the exact string customTitle.

Here's an illustration:

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

Answer 3

Answer №2

I've discovered that utilizing RegExp in Mongoose and JavaScript is effective.

Here is an example of Mongoose RegExp in action:

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);
      }
  });

Additionally, here is an example of JavaScript RegExp being utilized:

  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);
        }
    });

Answer 4

I've discovered that utilizing RegExp in Mongoose and JavaScript is effective.

Here is an example of Mongoose RegExp in action:

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);
      }
  });

Additionally, here is an example of JavaScript RegExp being utilized:

  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);
        }
    });

Querying a Mongoose database in express.js using the "like" command for strings

Answer №1

Answer №2

Similar questions

The Vue app utilizing Flickr API encounters an issue: "Unable to assign value to 'data' property as it is undefined."

How to attach input to function invocation in Angular 2

Encountering an error while using $state.go function in Angular JS testing

Steps for including a header and footer with page numbers in an HTML page without disrupting the rest of the content when printing

Changing text on a button with JavaScript toggle functionality: A step-by-step guide

Uncertainty arises from the information transmitted from the controller to the Ajax function

Failure occurs when attempting to send an object with an empty array using jQuery ajax

Running compiler-produced assembler code within the program

Transforming a value within a controller into a directive

Content that is dynamically generated by a database

Utilizing JSON and select for dependency management

Make the jQuery toggle() function work like a regular radio button when selecting multiple options at a time

Trouble seeing span in ion-item in Ionic 2: How can I display plain text instead?

Steps for removing every image from a folder

CSS3 Perspective Issue: Solutions for Fixing

Turn off choices by utilizing data type attribute values within select2 version 4

Node.js: Deciding between res.render and res.redirect in express-session

The responsiveness of Slick Slider's breakpoints is malfunctioning

Vue dynamic components fail to re-render within a v-for loop upon data changes

What is the purpose of Access-Control-Allow-Headers in an HTTP response and why is it important to include it?