rails 4 scope NOTNULL refactor

Question

I had to create a scope to create active jobs, but this feels a little odd and honestly it's tightly coupled to PosgresSQL:

  scope :active, -> { where('reviewed_at NOTNULL and paid_at NOTNULL and end_at >= ?', Date.today) }

Would you write this differently? Thank you

Answer 1

A shorter & more beautiful version will be like this:

scope :active, -> { where.not(reviewed_at: nil, paid_at: nil).where('end_at >= ?', Date.today) }

Answer 2

you can use where.not in rails 4

scope :active, -> { where.not(reviewed_at: nil).where.not(paid_at: nil).where('end_at >= ?', Date.today) }