1//First method
2// selecting authorityId :12 or 13
3model.findAll({
4 where: {
5 [Op.or]: [
6 { authorId: 12 },
7 { authorId: 13 }
8 ]
9 }
10});
1 // Number comparisons
2 [Op.gt]: 6, // > 6
3 [Op.gte]: 6, // >= 6
4 [Op.lt]: 10, // < 10
5 [Op.lte]: 10, // <= 10
6 [Op.between]: [6, 10], // BETWEEN 6 AND 10
7 [Op.notBetween]: [11, 15], // NOT BETWEEN 11 AND 15
1// second method
2// selecting authorityId :12 or 13
3model.findAll({
4 where: {
5 authorId: {
6 [Op.or]: [12, 13]
7 }
8 }
9});