Rails Scope Not Working When Regular where() Query Does

Question

I am trying to build a relatively simple named scope in my Products class. Oddly, if I issue the query directly (a la Product.where()), I get the results I expect. However, if this query is changed to a scope declaration, the result set is nil.

Why does my query work when called directly but produce nothing when it is made into a scope? Here's the actual code:

scope :is_queued, where("status = 2 OR (status = 0 AND status_expires > ?)", DateTime.now )# <-- returns nil
Product.where("status = 2 OR (status = 0 AND status_expires > ?)", DateTime.now) # <-- returns 1+ results (as expected)

Thank you!

Tom

Chowlett · Accepted Answer · 2012-03-03 14:58:43Z

3

Scopes defined with scope are evaluated once, when the scope is defined - so DateTime.now refers to when your app instance first started.

Try:

scope :is_queued, lambda { where("status = 2 OR (status = 0 AND status_expires > ?)", DateTime.now) }

answered Mar 3, 2012 at 14:58

Chowlett

47k21 gold badges119 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tom Corelis Over a year ago

Turned out to be a combination of this, plus a forgotten-about empty is_queued class method hanging out further down the file. Oops! :-) Thank you.

Collectives™ on Stack Overflow

Rails Scope Not Working When Regular where() Query Does

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related