How to ensure consistent ordering when sorting?

[ddahan]

When sorting the table by clicking on a header, if there are rows that have the same value, the order can not be consistent from one query to another. Is there a way to specify a "secondary" sorting criteria?

For example, when user clicks on the price header to sort rows by price, behind the scene I'd like to have ordering = (price, pk) sothat the result is guarantee to be the same, given the same queryset.

For now, I succeeded with :

price = tables.Column(order_by=["price", "id"])

However, doing this for every column is tedious, there must be a better way.

Thanks.

[jieter]

However, doing this for every column is tedious, there must be a better way.

Currently, there is no way to define an extra field to sort on. I'm not convinced that this is a feature worth implementing: certain columns would not need this, how do you suppose to configure that? I'd say this case should be solved by explicitly adding the order_by arguments to the columns.