How to use the and function from sequelize

chatrequest.js

GitHub: christinadivya/bot-one-one

342
343
344
345
346
347
348
349
350
351
input.TCHAT_REQUEST_Status = 'Request';
input.TCHAT_REQUEST_Created_On = new Date().toISOString().slice(0, 19).replace('T', ' ');
// input.TCHAT_REQUEST_Mobile_dateTime=req.body.TCHAT_REQUEST_Mobile_dateTime
Chatrequest.findAll({
  where: Sequelize.or(
    Sequelize.and(
      { TCHAT_REQUEST_Sender: input.TCHAT_REQUEST_Sender },
      { TCHAT_REQUEST_Receiver: input.TCHAT_REQUEST_Receiver },
      { TCHAT_REQUEST_IS_Delete: false }
    ),

0

1

1

+ 7 other calls in file

brand_product.controller.js

GitHub: faizanrazashah/Brand-retailer-marketplace

145
146
147
148
149
150
151
152
153
154
  created_by: req.body.mt_user_id,
  status: 1,
};
const newName = req.body.br_product_name.trim();
Brand_product.findAll({
  where: Sequelize.and(
    Sequelize.where(
      Sequelize.fn("lower", Sequelize.col("br_product_name")),
      Sequelize.fn("lower", newName)
    ),

0

0

1

+ 3 other calls in file