Filtering a query using Node JS and MongoDB

Question

I am new to MangoDB and Node JS. I have always worked on SQL databases and I do not know the syntax of MongoDB well. I wanna try to filter the array that I receive from a MongoDB database. I know that JavaScript has a .filter() function to filter just the results that contain a string. Is it best practice to get all the objects from MongoDB and filter in Node or do I let MongoDB do the filtering?

My Node.JS project is a back-end project using Node.JS and Express to do CRUD operations on a MongoDB database. In the request I send a parameter called 'equalTo' that contains the value that should be filtered on.

var router = express.Router();
var Plot = require("./models/plot");

...

router.get("/plots", (req, res) => {
   let query = "" + req.query.equalTo;
   Plot.find((err, plots) => {
      if (err) {
         res.send(err);
      }
      res.json(plots);
   });
});

The filtering should be an OR filter where all results where either the name or the cropName should CONTAIN the value of the string. If it is possible I would also like the comparison to ignore uppercase's. Here is a schema for the Plot object:

const plotSchema = mongoose.Schema({
   area: {
      type: String,
      required: true
   },
   comments: {
      type: String,
      required: true
   },
   cropGroupName: {
      type: String,
      required: true
   },
   cropName: {
      type: String,
      required: true
   },
   name: {
      type: String,
      required: true
   },
   plotId: {
      type: Number,
      required: true
   },
   coords: {
      type: [],
      required: true
   },
}, {
   collection: "plots"
});

CyberMessiah · Accepted Answer · 2020-04-04 17:58:00Z

2

The format is the following:

Plot.find({$or:[{name: "anyname"},{cropName:"othername"}]})

For further information you can read here https://docs.mongodb.com/manual/reference/operator/query/or/ You may replace the strings above in your case with equalTo.

edited Apr 4, 2020 at 17:58

answered Apr 4, 2020 at 17:48

CyberMessiah

1,29012 silver badges14 bronze badges

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

4 Comments

Stephen Over a year ago

Thanks. The only question I still have is how do i combine this with a contains and ignoring uppercase?

CyberMessiah Over a year ago

@user3566338 You can try some regular expression over the string.

Stephen Over a year ago

{ name: { $regex: ".*" + query + ".*", $options: "i" } }. This did the trick.

CyberMessiah Over a year ago

BTW, if you are building in React you may consider doing filtering over there, just an idea.

Collectives™ on Stack Overflow

Filtering a query using Node JS and MongoDB

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related