create a filter in django-datatables-view

Question

I use django-datatables-view to render a huge dataset. I try to filter 'flat_price'. It should be less or equal than a number that user writes in an input field

That's my DataTablesView:

class OrderListJson(BaseDatatableView):
    model = Flat
    columns = ['flat_house.adress', 'flat_price',]
    order_columns = ['flat_house.adress', 'flat_price',]
    max_display_length = 100

    def filter_queryset(self, qs):
        search = self.request.GET.get(u'search[value]', None)
        if search:
            qs = qs.filter(flat_price__lte=search)

I can't understand how filter_queryset works. When I try to load page with the datatable I've encountered with AttributeError : 'NoneType object has no attribute count'

score 2 · Accepted Answer · edited Apr 27 '16 at 14:32

2

filter_queryset should return queryset.

In your code, filter_queryset(self, qs) does not return any data. so, OrderListJson.get() use NoneType as a queryset

def filter_queryset(self, qs):
    search = self.request.GET.get(u'search[value]', None)
    if search:
        qs = qs.filter(flat_price__lte=search)
    return qs

edited Apr 27 '16 at 14:32

AKS

18,983
3
43
54

answered Apr 27 '16 at 14:30

beCurious

152
7

Thanks! Is it possible to write a custom filter in `BaseDatatableView` for another field in a html template? – mailman_73 Apr 27 '16 at 17:55
@mailman_73 Did you figure out how to create a custom filter? – Milano Jan 03 '17 at 14:05

score 1 · Answer 2 · answered Feb 16 '21 at 14:22

You should return the filtered query

    def filter_queryset(self, qs):
        search = self.request.GET.get(u'search[value]', None)
        print(search)
        if search:
            qs = qs.filter(
                Q(field1__icontains=search) |
                Q(field2__icontains=search)
            )
        return qs

replace field1 and field2 with your modal's fields that you want them to be searchable. ** Q is imported from **

from django.db.models import Q

create a filter in django-datatables-view

2 Answers2