Django: django-tables2 Changing default sort behaviour

Question

I'm experimenting with django-tables2. I've created a test site that displays a column of dates (created by timezone.now()). By default, the dates are ordered Oldest->Newest. If I click on column header, the dates are displayed in reverse order (the desired default behavior).

I've played around with the order_by argument, but I'm doing something wrong. My tables.py:

class OrderTable(tables.Table):
    order_date = tables.Column(order_by=("Order Date",))

My views.py:

def index(request):
    table = OrderTable(Order.objects.all())
    RequestConfig(request, paginate={"per_page": 10}).configure(table)
    return render(request, 'orders_app/index.html', {'table': table})

How can I order the "Order Date" column so its displayed as Newest->Oldest?

David Cain · Accepted Answer · 2013-11-04 17:18:52Z

6

Just prefix a '-' before the column name to reverse the order. You can supply order_by at the time of initializing the table.

def index(request):
    table = OrderTable(Order.objects.all(), order_by="-order_date")
    RequestConfig(request, paginate={"per_page": 10}).configure(table)
    return render(request, 'orders_app/index.html', {'table': table})

See order_by:

The default ordering. e.g. ('name', '-age'). A hyphen - can be used to prefix a column name to indicate descending order.

Also, see specifying alternative ordering for a column

edited Nov 4, 2013 at 17:18

answered Nov 4, 2013 at 16:49

David Cain

17.5k14 gold badges69 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

David Cain Over a year ago

My apologies. I've revised the answer, it should fit your needs.

intelis Over a year ago

Is it possible to do something like this with multiple values?

jbub · Accepted Answer · 2013-11-04 17:19:05Z

2

You can either set ordering on your queryset like this:

table = OrderTable(Order.objects.order_by('-Order Date'))

or using the table object directly:

table = OrderTable(Order.objects.all())
table.order_by = '-Order Date'

answered Nov 4, 2013 at 17:19

jbub

2,66526 silver badges23 bronze badges

4 Comments

Dirty Penguin Over a year ago

I tried your suggestion but it didn't work. It looks like I have to specify the actual variable name '-order_date' instead of '-Order Date'.

jbub Over a year ago

Well, you should edit your question then, you specified that the column name is "Order Date", clearly you have the "order_date" attribute in your model ...

Dirty Penguin Over a year ago

I meant "column" as in what is rendered by the browser. Clearly I can't have spaces in variable names.

jbub Over a year ago

Well you can in your database ... anyway, i think you got it working

Collectives™ on Stack Overflow

Django: django-tables2 Changing default sort behaviour

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related