Target Version does not sort
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?
#2 Updated by Ewan Makepeace over 11 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?