It might be a good idea to make the headers of the pagers links that sort the column. For example phpMyAdmin uses this.
It should be an optional feature, so not all columns are sortable, because sometimes you will not want a column to be sortable.
The approach might be to dynamically set the last part of the pager query: so ORDER BY ... DESC are dynamically created from the url.
this would result in eg:
* http://drupal.org/tracker for default view
* http://drupal.org/tracker/order/author/desc when somebody clicked on 'author header'
Can be done, not easy, but it is possible.
Ber
Comments
Comment #1
ax commentedjust yesterday, i wanted to submit exactly the same feature request.
+10.
(btw, this doesn't look really complicated to me)
Comment #2
ax commentedComment #3
moshe weitzman commentedAn interesting aproach to sorting is to do it all client-side, thus speeding things up for the user a lot. See this IRT article.
One drawback to client-side sorting is that it doesn't play nice with our notion of paging. It probably makes sense only for shorter tables when all data fits on a single page.
Comment #4
matt westgate commentedMoshe and I have been working on this feature. It works as expected in it's current state, but Dries would like to see it tweaked a little more so that is easier to use. I'm not sure how to do this, so feel free to hack away and submit.
Comment #5
moshe weitzman commentedThe current best effort is at
http://lists.drupal.org/pipermail/drupal-devel/2003-July/027401.html
The next step is to integrate this into an existing module (probably one
from Contrib). This will force us to make a clean API that module authors
can easily use. The API is fairly clean already, but may be improved.
I don't expect to work on this either. Hopefully someone else will
Comment #6
moshe weitzman commenteda patch introducing this functionality is in my sandbox and awaits review.
Comment #7
moshe weitzman commented