| @@ -425,9 +425,9 class Project < ActiveRecord::Base | |||
|
|
425 | 425 | def rolled_up_trackers |
|
|
426 | 426 | @rolled_up_trackers ||= |
|
|
427 | 427 | Tracker. |
|
|
428 |
joins( |
|
|
|
429 | joins("JOIN #{EnabledModule.table_name} ON #{EnabledModule.table_name}.project_id = #{Project.table_name}.id AND #{EnabledModule.table_name}.name = 'issue_tracking'"). | |
|
|
428 | joins(projects: :enabled_modules). | |
|
|
430 | 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 | 431 | uniq. |
|
|
432 | 432 | sorted. |
|
|
433 | 433 | to_a |
General Comments 0
You need to be logged in to leave comments.
Login now