##// END OF EJS Templates
Use association instead of a manual JOIN (#21583)....
Jean-Philippe Lang -
r14680:3a52b08405ad
parent child
Show More
@@ -425,9 +425,9 class Project < ActiveRecord::Base
425 def rolled_up_trackers
425 def rolled_up_trackers
426 @rolled_up_trackers ||=
426 @rolled_up_trackers ||=
427 Tracker.
427 Tracker.
428 joins(:projects).
428 joins(projects: :enabled_modules).
429 joins("JOIN #{EnabledModule.table_name} ON #{EnabledModule.table_name}.project_id = #{Project.table_name}.id AND #{EnabledModule.table_name}.name = 'issue_tracking'").
430 where("#{Project.table_name}.lft >= ? AND #{Project.table_name}.rgt <= ? AND #{Project.table_name}.status <> ?", lft, rgt, STATUS_ARCHIVED).
429 where("#{Project.table_name}.lft >= ? AND #{Project.table_name}.rgt <= ? AND #{Project.table_name}.status <> ?", lft, rgt, STATUS_ARCHIVED).
430 where("#{EnabledModule.table_name}.name = ?", 'issue_tracking').
431 uniq.
431 uniq.
432 sorted.
432 sorted.
433 to_a
433 to_a
General Comments 0
You need to be logged in to leave comments. Login now