You're not going to be happy :(
Hmm. I really don't like using the BogusQuerySet for all of the views. When possible (everything except the "All Incoming Review Requests" page), we should let the database do the sort/limit. What this evaluates to is basically "SELECT * FROM blah", when what we want is "SELECT * FROM blah ORDER BY blah blah blah LIMIT blah". MySQL's finely tuned C code will be faster doing this than your python ;) When I named that object, it was in the Toejam & Earl sense of the word "Bogus", like when you eat a moldy cheeseburger.
Add sortable columns to the dashboard and review request lists
Review Request #106 — Created July 1, 2007 and submitted
|Review Board SVN (deprecated)|
Added support for sorting review requests in the dashboard and various lists (submitters, groups, all). The columns are now clickable and will cause the list to sort. Up to three columns can be taken into consideration for sorting at any given point. We update the columns when clicked as follows: * If the column is not in the existing sort list, it becomes the primary sort column and we display a large down arrow. * If the column is in the existing sort list and is the primary sort column, we reverse the order of the column and display a large up arrow. * If the column is in the sort list but is not the primary sort column, we make it the primary sort column, and we don't reverse the order. We save a cookie every time the order changes and use that next time unless a ?sort= parameter is set.
Sorted various columns and messed with each case above. Appears to work correctly.