Defect #1502
closedTarget Version does not sort
0%
Description
I an running svn head (Redmine 0.7.devel.1557 (MySQL)), and clicking target version does not sort properly. The columns are all in random order.
My versions, I guess are strings "0.4", "0.5", "0.6" and clicking target version just re-arranges the rows and seems to be putting it into ID# order regardless doing it ascending or descending.
All my other columns appear to sort fine.
Aaah it appears to be using the Version Effective Date, which I have as blank (NULL?), I only fill in the date when I cut that version loose. In that sense it works and sorts my closed/released versions correctly.
I think it should sort by its Name field rather than its date field?
Related issues
Updated by Ewan Makepeace about 16 years ago
Updated by Ewan Makepeace about 16 years ago
Aha now I see. That was honestly a horrible design decision! If you want to sort versions by target date (which makes sense) then make the date field a required field. Sorting on an optional field is completely opaque to the user.
Can we not sort by date and name: ...ORDER BY targetVersion.Date, targetVersion.Name...
That way you still get date sorting where present and name sorting otherwise?
Updated by Jean-Philippe Lang almost 16 years ago
- Status changed from New to Closed
- Target version set to 0.9.0
- Resolution set to Fixed
Fixed in r2352. The sort now uses version date and name.