#3742 tracker browse sort by submitter or assignee isn't sorted [24302]

unreleased
open
nobody
General
nobody
2013-03-07
2012-02-14
Chris Tsai
No

https://sourceforge.net/apps/trac/sourceforge/ticket/24302

the submitter or assignee columns when you click on them are not sorted by userid but I think are sorted by the user's real name (which is hidden) OR are simply SQL GROUP BY'd.

whatever the case, the 2 columns are not sorted by userid, and it makes it very hard for users to jump ahead 200 pages since everything is random (but grouped).

So, 2 issues possibly here?

1) I tried sorting allura's tickets by "owner", and it doesn't seem to sort any discernible way

2) when I sort allura tickets by QA, it appears to sort correctly, but by username, not display name, which might be preferable behavior, however it's the display name that's shown, so it may be confusing.

Related

Tickets: #2576

Discussion

  • Anonymous - 2012-08-24

    Originally by: scoop

    • milestone: limbo --> forge-backlog
     
  • Chris Tsai - 2012-09-26
    • labels: support --> support, p3
     
  • Chris Tsai - 2013-02-14
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -6,6 +6,6 @@
    
     So, 2 issues possibly here?
    
    -1) I tried sorting allura's tickets by "owner", and it doesn't seem to sort any discernible way: <https://sourceforge.net/p/allura/tickets/?q={"status"%3A+{"%24in"%3A+["in-progress"%2C+"blocked"%2C+"validation"%2C+"open"%2C+"code-review"]}}&sort=assigned_to_username+desc&limit=250>
    +1) I tried sorting allura's tickets by "owner", and it doesn't seem to sort any discernible way
    
     2) when I sort allura tickets by QA, it appears to sort correctly, but by username, not display name, which might be preferable behavior, however it's the display name that's shown, so it may be confusing.
    
     
  • Chris Tsai - 2013-03-05

    Also see comments in https://sourceforge.net/p/forge/site-support/2904/#3990

    Perhaps some additional fixing is also necessary.

     

Log in to post a comment.