Defect #1502

Target Version does not sort

Added by Stuart George about 14 years ago. Updated over 13 years ago.

Status:ClosedStart date:2008-06-19
Priority:NormalDue date:
Assignee:-% Done:


Target version:0.9.0
Resolution:Fixed Affected version:


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?

Related issues

Duplicated by Redmine - Defect #3767: sorting issues list by target version doesn't work Closed 2009-08-21
Duplicated by Redmine - Defect #2534: Sorting Tickets for Target Version does not work in Saved... Closed 2009-01-19

Associated revisions

Revision 2352
Added by Jean-Philippe Lang over 13 years ago

Include both version date and name when sorting issues by target version (#1502).


#1 Updated by Ewan Makepeace almost 14 years ago

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...

#2 Updated by Ewan Makepeace almost 14 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?

#3 Updated by Jean-Philippe Lang over 13 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.

Also available in: Atom PDF