[Solved]-Non-queryset data ordering in django-tables2

by

4👍

You can’t use a queryset if you’re ordering on an attribute that doesn’t have a database column. You can pass a list to your table though.

Assuming your models.py looks like this:

from django.db import models

class MyModel(models.Model):
    def foo(self):
        return something_complex()

You could have tables.py that looks like this:

import django_tables2 as tables
from .models import MyModel

class MyModelTable(tables.Table):
    foo = tables.Column()

    class Meta:
        model = MyModel

Then in your views.py:

from django_tables2.config import RequestConfig
from django.core.paginator import InvalidPage
from django.shortcuts import render

def view_my_models(request):
    # use a list so django_tables2 sorts in memory
    my_models = list(MyModel.objects.all())

    my_models_table = MyModelTable(my_models)
    RequestConfig(request).configure(my_models_table)

    try:
        page_number = int(request.GET.get('page'))
    except (ValueError, TypeError):
        page_number = 1

    try:
        my_models_table.paginate(page=page_number, per_page=10)
    except InvalidPage:
        my_models_table.paginate(page=1, per_page=10)

    template_vars = {'table': my_models_table}
    return render(response, "view_my_models.html", template_vars)

There’s also an open ticket discussing this issue.

👤Wilfred Hughes

Leave a comment