Rails scope with 2 where clauses

I have a rails scope statement where I want 2 where clauses. (I will clean up the hardcoding when I've got it working).

This is in my workorder model:

  scope :laborok, where("wostatus_id NOT IN (?)", [231, 230, 8466, 8467, 232] ) and where("maxsynch = (?)", "N" )

The logic is if the workorder status (wostatus.id) is not one on the values and the workorder.maxsynch is equal to "N"

Answers


you can chain the where() methods:

scope :laborok, where("wostatus_id NOT IN (?)", [1]).where("maxsynch = (?)", "N")

Whatch out, I replaced your array of IDs with [1]! Here is the code with your array of IDs:

scope :laborok, where("wostatus_id NOT IN (?)", [231, 230, 8466, 8467, 232]).
                  where("maxsynch = (?)", "N")

Need Your Help

List of objects that have a list of other objects as one of their parameters

list object

I have this object Object1 defined as public Object1(String item, List<Object2> obj2) in a class (whilst Object2 is defined in another class as public Object2(String item1, String item2))

Bootstrap 3 menu dropdown strange BUG

javascript css html5 css3 twitter-bootstrap-3

I am making a site usng bootstrap 3. Now the problem is with navbar dropdown.