Filter issues in lib API QUERY PARAMS

Question

I am using this lib to apply filters

api-query-params

I need to perform the filter for this entity;

'use strict'

const mongoose = require('mongoose');
const Schema = mongoose.Schema;


const schema = new Schema({
    id: {
        type: String,
        trim: true
    },
    name: {
        type: String,
        trim: true

    },
    description: {
        type: String,
        trim: true
    },
    restaurantId: {
        type: String,
        trim: true
    },
    price: {
        type: Number,
        trim: true
    },

})

module.exports = mongoose.model('Menu', schema);

Through the lib documentation API QUERY PARAMS can create this method;

exports.list_all_dataProviders = async (req, res) => {
     const { filter, skip, limit, sort, projection } = aqp(req.query);

    Menus
      .find(filter)
      .skip(skip)
      .limit(limit)
      .sort(sort)
      .select(projection)
      .exec(async (err, result) => {

        if (err) {
          return res.status(500).jsonp({message:"There was an internal error listing all the providers " + err});
        }
        let count = await Menus.find().count()
        res.status(200).jsonp({
          size: limit,
          page: skip,
          total: count,
          data: result
        });
      });
  };

And I took the following test at the Postman;

http://localhost:3000/menu?price=14.9

http://localhost:3000/menu?price=4.9

http://localhost:3000/menu?price=6.9

And it stuck perfectly, but I took this test and I didn’t succeed;

It failed to perform any filter for the Description field http://localhost:3000/menu?description=Coberto

And for the name field only managed to get the first record.

What’s wrong is my method, I need to correct.

Answer 1

You did not present the data you have in your database, but by subtended in your question you want to search the items that contain the text that was passed, so you should use a regular expression indicating this. Your URL will change to:

http://localhost:3000/menu?description=/coberto/i

The modifier i determines that the search will ignore the case of his string.