907710 - Add UI to reverse sort order

Status: RESOLVED FIXED

(Bugzilla :: Query/Bug List, enhancement)

Description

[Jeff Muizelaar [:jrmuizel]]

It would be nice if this was possible from the advance query ui

Comment 1

[Andre Klapper]

Reverse sort order after sorting by what? Please elaborate.

Comment 2

[Jeff Muizelaar [:jrmuizel]]

Sorry I meant to mention this in the summary. See bug 906913 for the use case.

Comment 3

[David Lawrence [:dkl]]

We could just add "Bug Number Descending" to the sort drop down on the advanced query page.

dkl

Comment 4

[Frédéric Buclin]

(In reply to David Lawrence [:dkl] from comment #3)
> We could just add "Bug Number Descending" to the sort drop down on the
> advanced query page.

I see no reason to do it for bug IDs only. A checkbox "reverse order" besides the select field would work better, IMO.

Comment 5

[Simon Green]

(In reply to Frédéric Buclin from comment #4)
> I see no reason to do it for bug IDs only. A checkbox "reverse order"
> besides the select field would work better, IMO.

+1

Comment 6

[Adam Muntner [:adamm] (use NEEDINFO)]

Following up on this bug. It would be a big time saver for security bug handlers, and I imagine for anyone who tracks a queue of bugs. 

How expensive are searches for Bugzilla, could configuring saved descending sort options lessen the load?

I still have a bunch of queries I haven't updated with 'the hack' where each time I click the search link, I have to wait for the search to complete, then click sort by x to get it into the right order, A great percentage of my search queries are resorting, this is how most people use Bugzilla.

Comment 7

[David Lawrence [:dkl]]

(In reply to Adam Muntner [:adamm] (use NEEDINFO) from comment #6)
> Following up on this bug. It would be a big time saver for security bug
> handlers, and I imagine for anyone who tracks a queue of bugs. 
> 
> How expensive are searches for Bugzilla, could configuring saved descending
> sort options lessen the load?
> 
> I still have a bunch of queries I haven't updated with 'the hack' where each
> time I click the search link, I have to wait for the search to complete,
> then click sort by x to get it into the right order, A great percentage of
> my search queries are resorting, this is how most people use Bugzilla.

BMO uses JS sorting code on the buglist.cgi page so it is not immediately obvious that you can manually sort the results and remember the URL with the new sort order.

If you add the following to your search URL, you can get the sorting you want:

https://bugzilla.mozilla.org/buglist.cgi?order=bug_id DESC

You can string multiple columns as well such as &order=bug_id DESC,bug_status,priority ASC,... and it will sort each one in order as if you had clicked on each column one at a time. The proper thing to do would be to make the JS code manipulate the order value in the URL so you can still bookmark it without doing it manually.

But we can definitely add the "Descending" checkbox on the advanced search page for the pre-set sort orders.

dkl

Comment 8

[David Lawrence [:dkl]]

Attachment: 907710_1.patch

Comment 9

[Frédéric Buclin]

Comment on attachment 8746730 [details] [diff] [review]
907710_1.patch

r=LpSolit

Comment 10

[David Lawrence [:dkl]]

To ssh://[e-mail]/bugzilla/bugzilla.git
   0748e84..2db8904  master -> master