Express API REST Filter Data MongoDB

Question

I have a Pokemon API REST with express and mongo. Im trying to filter pokemon by his type.

I send from Angular a http GET with the type to filter on params.

Having the following controller.js

const pokemons = require('../models/pokemon');
const laboratoryCtrl = {};

laboratoryCtrl.filterPokemon = async (req, res) => {
  const filterType = req.query.type; // filterType = "Fire"
  const pokemon = await pokemons.find({ $or : [{type: /^Fire/}, {type2: /^Fire/}] })
   .sort({ pokedex: + 1 });
      res.json(pokemon);
   }

module.exports = laboratoryCtrl;

How can I use the value of "filterType" thats actually Fire in the .find() method?

Is this a good way of filtering data? this is my first API REST and my first express + mongo project

chridam · Accepted Answer · 2018-08-07 15:27:53Z

1

Use the RegExp constructor to create a regular expression instance with the filterType variable:

const rgx = new RegExp(`^${req.query.type}`); //or new RegExp('^'+req.query.type)
const pokemon = await pokemons.find({ 
    '$or': [
        { 'type' : rgx }, 
        { 'type2': rgx }
    ] 
}).sort({ pokedex: + 1 });
res.json(pokemon);

answered Aug 7, 2018 at 15:27

chridam

104k26 gold badges246 silver badges243 bronze badges

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

5 Comments

Sergi Over a year ago

hey @chridam can you help me again? how can i do the same but this time with the sort() method and the pokedex property, im getting /pokedex/ always, i just need "pokedex"

Sergi Over a year ago

nvm i found the solution, i share so maybe others can use it const filterStat = new Object(); filterStat[req.query.type] = + 1;

Sergi Over a year ago

hey its me again! if I dont select a Type to filter, how can I set using Regexp the equivalent * on SQL? /^*/ /^''/ /^%/ not working

chridam Over a year ago

You will have to escape it with a backlash e.g new RegExp("^\\*")

Sergi Over a year ago

With your info i could search better and found the solution /.*?/

Collectives™ on Stack Overflow

Express API REST Filter Data MongoDB

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related