find all data using same field and different values in mysql sequelize

Question

I need to find the data using same field on mysql, but different values. but i geetting empty values in response.

I tried the $and condition to find the data on sequelize. but it getting not data in response.

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

 const wherequery = { 
             $and: [{ id: { eq: 1 } },
                    { id: { eq: 2 } }
                   ] };
 branch.findAll(wherequery)

.then(data => res.status(200).send(data))

.catch(Sequelize.ValidationError, err => 
 res.status(422).send(err.errors[0].message))

.catch(err => res.status(400).send(err.message));
 };

Vishal · Accepted Answer · 2019-02-12 05:10:03Z

1

Try OR query :-

 const wherequery = { 
             $or: [{ id: { eq: 1 } },
                    { id: { eq: 2 } }
                   ] };

answered Feb 12, 2019 at 5:10

Vishal

1,2901 gold badge8 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

find all data using same field and different values in mysql sequelize

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related