Node.js Sequelize: multiple condition on 'where'

Question

How do i query a table with multiple conditions? This give me no error but, only run the first condition!

exports.findAllLimit = (req, res) => {

 const titulo  = req.query.titulo ;
 var condition = titulo ? { titulo : { [Op.iLike]: `%${titulo }%` } } : null;
 var condition2 = {stock: {  [Op.ne]: 0}};

 Produtos.findAll({ 
 where:  condition , condition2,
 include: [Categorias], 
  order: [ 
   ['id', 'ASC']
         ],
  limit: 9
  })
.then(data => {
  res.send(data);
})
.catch(err => {
  res.status(500).send({
    message:
        err.message || "Ocorreu um erro a retirar os dados do backend!."
  });
   });
 };

user6001402 · Accepted Answer · 2020-07-14 08:13:17Z

4

You create here an object with property condition2 and it's value. You need to merge these 2 conditions, and assign them on where. so you can use:

where: Object.assign({}, condition , condition2),

OR:

where: {...condition, ...condition2}

answered Jul 14, 2020 at 8:13

user6001402

1063 bronze badges

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

1 Comment

OurozZ Over a year ago

"where: Object.assign({}, condition , condition2)", Works! =) ty

Arpit Vyas · Accepted Answer · 2020-07-14 08:00:14Z

0

you can do like this for multiple condition .

const titulo  = req.query.titulo ;
var condition = titulo
  ? {
      titulo: {
        [Op.iLike]: `%${titulo}%`,
      },
    }
  : null;
var condition2 = {
  stock: {
    [Op.ne]: 0,
  },
};

let where = [];
where.push(condition);
where.push(condition2);

Produtos.findAll({
  where,
});

answered Jul 14, 2020 at 8:00

Arpit Vyas

2,2671 gold badge10 silver badges21 bronze badges

Collectives™ on Stack Overflow

Node.js Sequelize: multiple condition on 'where'

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related