Sortable table columns in django

Question

I want to have sortable columns in my tables (just like what is done for the admin changelists)....I'm looking for a solution that will be easy to implement and customize if I want.

How can I do this?

Answer 1

Javascript? There are plenty of table sorters out there:

• http://tablesorter.com/docs/
• http://kryogenix.org/code/browser/sorttable/
• http://friedcellcollective.net/js/SortedTable/
• http://www.leigeber.com/2009/03/table-sorter/
• http://www.millstream.com.au/view/code/tablekit

Answer 2

If you use pagination than a Javascript table sorter might not be sufficient or behave unexpected.

---

Create every column header as a link e.g.

<th><a href="?order_by=name">Name</a></th>

and in your view you check whether the order_by parameter is set or not:

order_by = request.GET.get('order_by', 'defaultOrderField');
Model.objects.all().order_by(order_by)