diff options
| author | Gareth Rees <gareth@mysociety.org> | 2014-10-01 13:32:14 +0100 |
|---|---|---|
| committer | Louise Crow <louise.crow@gmail.com> | 2014-12-18 15:16:38 +0000 |
| commit | 81bab2df2426bb0229aa769207b14e573f3515b7 (patch) | |
| tree | 6bd61e1ea444e5f00ca02aeb08746ecbf193def7 /app/models/user.rb | |
| parent | e35662cd62c781b144d4154568ac7fa0b4c45d36 (diff) | |
Improve User#get_undescribed_requests SQL
Diffstat (limited to 'app/models/user.rb')
| -rw-r--r-- | app/models/user.rb | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/app/models/user.rb b/app/models/user.rb index 1c6dc0eb0..c953e52f2 100644 --- a/app/models/user.rb +++ b/app/models/user.rb @@ -264,11 +264,9 @@ class User < ActiveRecord::Base # Returns list of requests which the user hasn't described (and last # changed more than a day ago) def get_undescribed_requests - info_requests.find( - :all, - :conditions => [ 'awaiting_description = ? and ' + InfoRequest.last_event_time_clause + ' < ?', - true, Time.now() - 1.day - ] + info_requests.where( + "awaiting_description = ? and #{ InfoRequest.last_event_time_clause } < ?", + true, 1.day.ago ) end |