Vote #63479
完了Target Version does not sort
0%
説明
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.
References #885, #832
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?
journals
I was about to report the same thing. Searching back this was reported before here: #885 and here #832 and reported fixed in r1264.
Not working any more...
--------------------------------------------------------------------------------
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?
--------------------------------------------------------------------------------
Fixed in r2352. The sort now uses version date and name.
--------------------------------------------------------------------------------
related_issues
duplicates,Closed,3767,sorting issues list by target version doesn't work
duplicates,Closed,2534,Sorting Tickets for Target Version does not work in Saved search over all projects