Using OR statement in sequelize where query

Question

I have some issue using or statement is sequelize. Below is the code I have been able to come up with:

UserExist(req, res) {
const field = req.body.username || req.body.email;
const getFieldName = field === req.body.username ? 'username' : 'email';
return User
  .findOne({ where: {
    $or: [
      {
        email: req.body.email,
        username: req.body.username
      }
    ]
  }
  })
  .then((user) => {
    if (user) {
      res.status(200).send({ message: `${getFieldName} already exist` });
    }
  })
  .catch(() => res.status(404).send({ message: '' }));

}

Instead of executing the OR statment it only selects * from Users

Hemant Kumar · Accepted Answer · 2017-08-29 18:01:26Z

9

According to the sequelize documentation

you should give different where conditions as different element of $or array

Please try this:

$or: [
  {
    email: req.body.email
  },
  {
    username: req.body.username
  }
]

answered Aug 29, 2017 at 18:01

Hemant Kumar

4763 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

Using OR statement in sequelize where query

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