diff --git a/app/models/issue.rb b/app/models/issue.rb index 3e19882..2111b04 100644 --- a/app/models/issue.rb +++ b/app/models/issue.rb @@ -1104,7 +1104,7 @@ class Issue < ActiveRecord::Base # Returns a scope of the given issues and their descendants def self.self_and_descendants(issues) - issue_ids = Issue.joins("JOIN #{Issue.table_name} ancestors" + + Issue.joins("JOIN #{Issue.table_name} ancestors" + " ON ancestors.root_id = #{Issue.table_name}.root_id" + " AND ancestors.lft <= #{Issue.table_name}.lft AND ancestors.rgt >= #{Issue.table_name}.rgt" ).