0001-groupable-by-parent-task.patch - Redmine

                 !issue.is_descendant_of?(ancestors.last)
             ancestors.pop
           end
           yield issue, ancestors.size, group_name, group_count, group_totals
           level = (query.grouped? && query.group_by_column.name == :parent) ? 0 : ancestors.size
           yield issue, level, group_name, group_count, group_totals
           ancestors << issue unless issue.leaf?
         end
       end

app/models/issue_query.rb
28	28	QueryColumn.new(:tracker, :sortable => "#{Tracker.table_name}.position", :groupable => true),
29	29	QueryColumn.new(:parent,
30	30	:sortable => ["#{Issue.table_name}.root_id", "#{Issue.table_name}.lft ASC"],
	31	:groupable => "#{Issue.table_name}.parent_id",
31	32	:default_order => 'desc', :caption => :field_parent_issue),
32	33	QueryAssociationColumn.new(:parent, :subject, :caption => :field_parent_issue_subject),
33	34	QueryColumn.new(:status, :sortable => "#{IssueStatus.table_name}.position", :groupable => true),

     # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
     class QueryColumn
       attr_accessor :name, :totalable, :default_order
       attr_writer   :sortable, :groupable
       attr_accessor :name, :totalable, :default_order, :groupable
       attr_writer   :sortable
       include Redmine::I18n
-...
           if column.is_a?(TimestampQueryColumn)
             column_sortable = Redmine::Database.timestamp_to_date(column.sortable, User.current.time_zone)
           end
           if column.name == :parent
             column_sortable = Array(column.groupable)
           end
           Array(column_sortable).map {|s| Arel.sql("#{s} #{order}")}
         end
       end

         assert_nil q.group_by_statement
       end
       def test_grouped_with_parent_task_should_sort_by_parent_id
         Issue.delete_all
         first, second, third  = Issue.generate!, Issue.generate!, Issue.generate!
         Issue.generate!(:parent_id => second.id)
         Issue.generate!(:parent_id => third.id)
         Issue.generate!(:parent_id => first.id)
         q = IssueQuery.new(:group_by => 'parent')
         assert_equal :parent, q.group_by_column.name
         assert_equal ["#{Issue.table_name}.parent_id DESC"], q.group_by_sort_order
         assert_equal [third.id, second.id, first.id, nil, nil, nil], q.issues.pluck(:parent_id)
       end
       def test_sortable_columns_should_sort_assignees_according_to_user_format_setting
         with_settings :user_format => 'lastname_comma_firstname' do
           q = IssueQuery.new

Redmine