allow sorting for all columns

[GoogleCodeExporter]

When I'm looking at the list of changes (open or all or whatever), I really 
want to be able to sort on various columns.  I don't see any way to do this 
in the current gerrit.

Original issue reported on code.google.com by kevin.la...@gmail.com on 16 Apr 2010 at 4:16

[GoogleCodeExporter]

Sorting on any given column requires that we have indexes for
every single one so that the database can efficiently range
scan to produce the results.

On smaller installations its no big deal, the sort can of
course take place in memory on the fly, computers are quite
fast at this.  But on larger installations that sort time
can contribute a lot of load to the server.

So thus far we only support sorting the all change lists
by last update time, descending, as that is the only field
we have indexed in the database.

We probably could open this up a bit more, there are a few
other indexes present, but I'd rather focus on things like
search filters or migrating out of SQL onto Git, where the
whole problem of search and sort becomes much more complex.

Original comment by sop@google.com on 16 Apr 2010 at 4:27

• Changed state: Accepted

[GoogleCodeExporter]

It would be invaluable to me to be able to sort a topic by the lineage of the 
commits.

Original comment by jrobert...@gmail.com on 6 Jul 2012 at 4:41

[GoogleCodeExporter]

yes, It should be very convenient to sort by branch, owner,projects...

Original comment by sword.l....@gmail.com on 10 Aug 2012 at 11:34

[GoogleCodeExporter]

I agree. Sorting a topic by commit order (the same way it's done in git log and 
tig) would make a lot of sense.

Original comment by jeremy.a...@gmail.com on 21 Nov 2012 at 4:17

[GoogleCodeExporter]

Could you add option for queries and for REST API to specify sort attribute:

eg:
is:open project:XXX sort:Update

Original comment by Iso.poc...@gmail.com on 12 Dec 2012 at 11:41

[GoogleCodeExporter]

Why not do it on the client (browser) side?

Wikimedia is a good example:
http://en.wikipedia.org/wiki/Help:Sorting

Of course it will only work on the displayed results.

Original comment by yoshi...@gmail.com on 18 Apr 2013 at 9:08

[GoogleCodeExporter]

Almost 4 years since there's been any productive movement here.

The dashboard search results (under "My Reviews" heading) is sorted the way my 
reviewers want to see them.  But the view that they get has them sorted by last 
updated time.  Why should I see them in the correct order, but no one else can? 
 Is there a way to make a dashboard to get the desired sorting?

Original comment by jhans...@meetme.com on 27 Mar 2014 at 8:02

[GoogleCodeExporter]

This is more than minor IMO.

We sometimes have a rush of reviews coming in and in theory we should start by 
the oldest one.

But this list is sorted by the new ones so these get tackled first and the 
older ones get forgotten if no one else is there to push them.

Please do consider this bug as more important than just eye candy.

Original comment by joel.sch...@dental-wings.com on 22 May 2015 at 2:00