Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

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

General Tech Bugs & Fixes

Max. 2000 characters
Replies

usr_profile.png

User

( 8 months ago )

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));
 };

usr_profile.png

User

( 8 months ago )

Try OR query :-

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

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif