Using sequelize, how do you use an OR operator with the where criteria?

Question

From a previous SO discussion I was able to update multiple sequelize instances with two conditions.

Can anyone explain how I can modify the sequelize .update method using a logical OR operator instead of an AND operator? Below is the sequelize .update method using AND for the two condition of updating.

  global.db.Task.update(
    {Desc: 'New Upate'},       //set attribute 
    {cd: 'match', Desc: null}  //where criteria 
  ).success(function(affectedRows) { ... });

This will read an SQL Statement as follows:

UPDATE "Task" SET "Desc"='New Update' WHERE "Cd"='match' AND "Desc" IS NULL

score 1 · Accepted Answer · edited Jul 01 '14 at 21:37

1

try

global.db.Task.update(
    {Desc: 'New Upate'},       //set attribute 
    ["cd = ? OR Desc = ?", 'match', null]  //where criteria 
  ).success(function(affectedRows) { ... });

Update (from Miller): Added a comma that I missed in at the end of the set attribute line.

edited Jul 01 '14 at 21:37

Val

1,260
5
23
39

answered Jul 01 '14 at 02:45

Kamrul

7,175
3
31
31

Are these changes you made considered raw SQL? – Val Jul 01 '14 at 21:27

score 0 · Answer 2 · answered May 30 '17 at 07:32

0

global.db.Task.update({update_data}, {where: {where_data}}).then(function (affectedrows) {})

 global.db.Task.update({Desc: 'New Upate'},  where: {$or: [{cd: "match"}, {Desc: null}]}).success(function(affectedRows) { ... });

answered May 30 '17 at 07:32

vijay kumar

1,025
13
11

Using sequelize, how do you use an OR operator with the where criteria?

2 Answers2