From 2ec53dd2952e67d1b6609fa8279e4b00d32ac339 2017-01-21 10:09:13
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: 2017-01-21 10:09:13
Subject: [PATCH] Clean up SQL.

git-svn-id: http://svn.redmine.org/redmine/trunk@16246 e93f8b46-1217-0410-a6f0-8f06a7374b81

---

diff --git a/app/models/issue.rb b/app/models/issue.rb
index 00e9899..40a12c0 100644
--- a/app/models/issue.rb
+++ b/app/models/issue.rb
@@ -79,13 +79,13 @@ class Issue < ActiveRecord::Base
   scope :open, lambda {|*args|
     is_closed = args.size > 0 ? !args.first : false
     joins(:status).
-    where("#{IssueStatus.table_name}.is_closed = ?", is_closed)
+    where(:issue_statuses => {:is_closed => is_closed})
   }
 
-  scope :recently_updated, lambda { order("#{Issue.table_name}.updated_on DESC") }
+  scope :recently_updated, lambda { order(:updated_on => :desc) }
   scope :on_active_project, lambda {
     joins(:project).
-    where("#{Project.table_name}.status = ?", Project::STATUS_ACTIVE)
+    where(:projects => {:status => Project::STATUS_ACTIVE})
   }
   scope :fixed_version, lambda {|versions|
     ids = [versions].flatten.compact.map {|v| v.is_a?(Version) ? v.id : v}