Project

General

Profile

Patch #21583 » project_nicer_trackers_query.diff

Ondřej Ezr, 2015-12-22 01:28

View differences:

app/models/project.rb
def rolled_up_trackers
@rolled_up_trackers ||=
Tracker.
joins(:projects).
joins("JOIN #{EnabledModule.table_name} ON #{EnabledModule.table_name}.project_id = #{Project.table_name}.id AND #{EnabledModule.table_name}.name = 'issue_tracking'").
joins(projects: :enabled_modules).
where("#{Project.table_name}.lft >= ? AND #{Project.table_name}.rgt <= ? AND #{Project.table_name}.status <> ?", lft, rgt, STATUS_ARCHIVED).
where("#{EnabledModule.table_name}.name = ?", 'issue_tracking').
uniq.
sorted.
to_a
    (1-1/1)