Feature #3511
Ability to sort issues by grouped column
| Status: | New | Start date: | 2009-06-18 | |
|---|---|---|---|---|
| Priority: | Low | Due date: | ||
| Assignee: | - | % Done: | 0% |
|
| Category: | Issues | |||
| Target version: | Candidate for next major release | |||
| Resolution: |
Description
When grouping issues by a column, specifying a sort on that same column is ignored (should determine order of groups). Sorting within groups using other fields does work.
Related issues
History
#1 Updated by Vladimir Goryachev almost 3 years ago
- Assignee set to Jean-Philippe Lang
Yes, very ugly bug.
Please fix.
#2 Updated by Jean-Philippe Lang almost 3 years ago
- Assignee deleted (
Jean-Philippe Lang) - Priority changed from Normal to Low
Please do not assign tickets to anyone.
#3 Updated by Paul McMillan almost 3 years ago
+1
This issue also affects me.
#4 Updated by Kai Krakow over 2 years ago
Please fix, still an issue in 0.9
#5 Updated by S Reid almost 2 years ago
Just upgraded to 0.9, and found this problem. Is this scheduled to be fixed ?
#6 Updated by Ondrej Hrebicek almost 2 years ago
Would love to see this fixed as well. Really makes the grouped view (when grouping by Version) impossible to use.
#7 Updated by Brian Lacy about 1 year ago
I just want to confirm that I'm still experiencing the same problem. Our most crucial report Groups by Target Version, and the default order is backwards! We have to scroll to the bottom of the report to see our most current Release. Very frustrating.
Redmine 1.0.4.stable.4552 (MySQL)
#8 Updated by S Reid about 1 year ago
Still an issue as of 1.1.1. Annoying when using group by target version, and have several pages of issues.
#9 Updated by Etienne Massip about 1 year ago
- Target version set to Candidate for next major release
#10 Updated by Cyber Sprocket about 1 year ago
bump.
Group by target version is an issue on our larger projects. Newer target versions, that we add later in the cycle, are sorting to the stop of the group-by list. Thus the current/active release always are pushed down near the bottom.
Sorting by target version should either sort alpha-numeric ascending (so v01.10 would show up before v01.20) or even better would be to make the system sort by release date if target version is the grouping (much like road map & settings/versions).
#11 Updated by Etienne Massip 9 months ago
- Tracker changed from Defect to Feature
#12 Updated by Etienne Massip 9 months ago
- Subject changed from Can't sort issues by grouped column to Ability to sort issues by grouped column
#13 Updated by Stefan Lindner 8 months ago
We too need a fix for this. Or, as it is a feature from now, we need this feature.
#14 Updated by Hans Jakobsen 8 months ago
+1
This is an important feature, so you can view the full Issue list like a roadmap. Please give it high priority so it can be included soon.
#16 Updated by Toggi Muppet 7 months ago
+ 1
Annoying when using issues with customer that the highest version comes on top.
#17 Updated by Adam Sneller 5 months ago
+ 1
The nice thing about grouping issues by version is that the unassigned issues form a product backlog. It would be helpful if these groupings could be sorted so that the current sprint/version is first on the list.
#18 Updated by Stéphane Thomas 3 months ago
+1
In the meantime, I've added the following patch in a new file config/initializers/versions.rb:
require 'app/models/query'
class Query < ActiveRecord::Base
after_initialize :reset_versions_order
# Updates the list of available columns to specify ascending as order for versions
def reset_versions_order
@@available_columns[10] = QueryColumn.new(:fixed_version, :sortable => ["#{Version.table_name}.effective_date", "#{Version.table_name}.name"], :default_order => 'asc', :groupable => true)
end
end
But maybe you can think of a better way to update this list of columns (those are my very first lines of code in RoR)?
#19 Updated by Michael Onevelo about 1 month ago
+1
#20 Updated by Nicola Bernardini 24 days ago
+1
I tried the patch by Stèphane but it does not work for me... Or at least I don't know how to make it work...
#21 Updated by Simeon Fitch 17 days ago
+1
Major efficiency impediment. Anyone have a temporary work around?
#22 Updated by Stéphane Thomas 16 days ago
I've just updated to Redmine 1.4.1 and indeed my patch did not work any more. Here is a new one:
require 'app/models/query'
class Query < ActiveRecord::Base
# Updates the list of available columns to specify ascending as order for versions
def after_initialize
@@available_columns[10] = QueryColumn.new(:fixed_version, :sortable => ["#{Version.table_name}.effective_date", "#{Version.table_name}.name"], :default_order => 'asc', :groupable => true)
end
end
#23 Updated by Stéphane Thomas 14 days ago
- File redmine_issue_versions_order.zip added
Since I've encountered some weird errors with this new patch when browsing issues, I did repackage it as a plugin. Enjoy!
#24 Updated by Rick Hunnicutt about 6 hours ago
Great, thank you! Just unzip it in the plugin directory and restart redmine?
#25 Updated by Stéphane Thomas about 6 hours ago
That's it, Rick!
#26 Updated by Rick Hunnicutt about 5 hours ago
So, just to be clear, this plugin only changes the sort order of the Versions from descending to ascending. It doesn't add the ability to (re)sort the groups in any way.