Filtering with django-filter

Introduction

django-filter helps you easily filter data in your Django apps without writing complex code. It makes searching and sorting data simple and user-friendly.

You want users to search or filter a list of items on a webpage.

You need to filter database records based on user input in forms.

You want to add filters to API endpoints to return specific data.

You want to avoid writing manual filtering logic in views.

You want a clean and reusable way to handle filtering in Django.

Syntax

Django

import django_filters
from .models import YourModel

class YourModelFilter(django_filters.FilterSet):
    class Meta:
        model = YourModel
        fields = ['field1', 'field2', 'field3']

Define a FilterSet class for your model to specify which fields can be filtered.

Use this FilterSet in your views to apply filtering automatically.

Examples

This filter lets users filter products by category and price.

Django

import django_filters
from .models import Product

class ProductFilter(django_filters.FilterSet):
    class Meta:
        model = Product
        fields = ['category', 'price']

This example adds a case-insensitive search on the book title.

Django

import django_filters
from .models import Book

class BookFilter(django_filters.FilterSet):
    title = django_filters.CharFilter(lookup_expr='icontains')

    class Meta:
        model = Book
        fields = ['title', 'author']

Sample Program

This view uses django-filter to filter products based on URL query parameters. The filtered products are passed to the template inside the filter object.

Django

import django_filters
from django.shortcuts import render
from .models import Product

class ProductFilter(django_filters.FilterSet):
    class Meta:
        model = Product
        fields = ['category', 'price']

def product_list(request):
    f = ProductFilter(request.GET, queryset=Product.objects.all())
    return render(request, 'product_list.html', {'filter': f})

Important Notes

Remember to install django-filter with pip install django-filter and add it to INSTALLED_APPS.

Use request.GET to get filter parameters from the URL.

django-filter works well with Django REST Framework for API filtering.

Summary

django-filter simplifies filtering data in Django apps.

Create a FilterSet class to define filterable fields.

Use the FilterSet in views to filter querysets based on user input.

Practice

1. What is the main purpose of using django-filter in a Django project?

easy

A. To create database tables automatically

B. To easily filter querysets based on user input without writing complex code

C. To handle user authentication and permissions

D. To generate HTML forms for user registration

Solution

1. Step 1: Understand django-filter's role

   django-filter is designed to simplify filtering data in Django apps by creating filters for querysets.

2. Step 2: Compare with other options

   Options A, C, and D relate to database creation, authentication, and form generation, which are not the main purpose of django-filter.

3. Final Answer:

   To easily filter querysets based on user input without writing complex code -> Option B

4. Quick Check:

   django-filter purpose = filtering querysets [OK]

Hint: django-filter = easy queryset filtering [OK]

Common Mistakes:

• Confusing django-filter with authentication libraries
• Thinking it creates database tables
• Assuming it generates forms for registration

2. Which of the following is the correct way to define a FilterSet class for a model named Book with a filter on the author field?

easy

A. class BookFilter(FilterSet):\n class Meta:\n model = Book\n fields = ['author']

B. class BookFilter(FilterSet):\n model = Book\n fields = ['author']

C. class BookFilter(FilterSet):\n class Meta:\n fields = ['author']

D. class BookFilter(FilterSet):\n class Meta:\n model = Book\n filter_fields = ['author']

Solution

1. Step 1: Recall FilterSet Meta class structure

   The Meta class must specify the model and the fields list for filtering.

2. Step 2: Check each option

   class BookFilter(FilterSet):\n class Meta:\n model = Book\n fields = ['author'] correctly defines Meta with model and fields. class BookFilter(FilterSet):\n model = Book\n fields = ['author'] misses Meta class. class BookFilter(FilterSet):\n class Meta:\n fields = ['author'] misses model. class BookFilter(FilterSet):\n class Meta:\n model = Book\n filter_fields = ['author'] uses incorrect attribute 'filter_fields'.

3. Final Answer:

   class BookFilter(FilterSet):\n class Meta:\n model = Book\n fields = ['author'] -> Option A

4. Quick Check:

   FilterSet Meta needs model and fields [OK]

Hint: FilterSet Meta needs model and fields list [OK]

Common Mistakes:

• Omitting the Meta class
• Using 'filter_fields' instead of 'fields'
• Not specifying the model in Meta

3. Given the following FilterSet and queryset, what will be the result of filtering with author='Alice'?

class BookFilter(FilterSet):
    class Meta:
        model = Book
        fields = ['author']

books = Book.objects.all()
filtered_books = BookFilter({'author': 'Alice'}, queryset=books).qs

medium

A. A queryset containing only books where the author field is 'Alice'

B. A queryset containing all books regardless of author

C. An empty queryset because 'author' is not a valid filter

D. A syntax error due to incorrect FilterSet usage

Solution

1. Step 1: Understand FilterSet filtering

   Providing {'author': 'Alice'} filters the queryset to only include books with author 'Alice'.

2. Step 2: Confirm no errors in code

   The FilterSet is correctly defined and used, so no syntax or runtime errors occur.

3. Final Answer:

   A queryset containing only books where the author field is 'Alice' -> Option A

4. Quick Check:

   FilterSet filters queryset by given field values [OK]

Hint: FilterSet with dict filters queryset by those values [OK]

Common Mistakes:

• Assuming it returns all books without filtering
• Thinking 'author' is invalid filter
• Confusing FilterSet with form validation errors

4. Identify the error in this FilterSet usage:

class BookFilter(FilterSet):
    class Meta:
        model = Book
        fields = ['title']

filter = BookFilter(request.GET)
filtered_books = filter.qs

medium

A. FilterSet class must inherit from django.forms.Form

B. Incorrect attribute name; should be filter.queryset instead of filter.qs

C. Fields list should include 'author' not 'title'

D. Missing queryset argument when creating BookFilter instance

Solution

1. Step 1: Check FilterSet instantiation

   BookFilter requires a queryset argument to filter; it's missing here.

2. Step 2: Verify attribute usage

   Using filter.qs is correct to get filtered queryset; no error there.

3. Final Answer:

   Missing queryset argument when creating BookFilter instance -> Option D

4. Quick Check:

   FilterSet needs queryset argument [OK]

Hint: Always pass queryset when instantiating FilterSet [OK]

Common Mistakes:

• Forgetting to pass queryset argument
• Using wrong attribute like filter.queryset
• Confusing FilterSet with Django forms inheritance

5. You want to filter a list of Product objects by price range using django-filter. Which FilterSet definition correctly allows filtering products with price greater than or equal to a minimum and less than or equal to a maximum?

hard

A. class ProductFilter(FilterSet):
price = RangeFilter()

class Meta:
model = Product
fields = ['price']

B. class ProductFilter(FilterSet):
class Meta:
model = Product
fields = ['price__gte', 'price__lte']

C. class ProductFilter(FilterSet):
price_min = NumberFilter(lookup_expr='gte')
price_max = NumberFilter(lookup_expr='lte')

class Meta:
model = Product
fields = ['price_min', 'price_max']

D. class ProductFilter(FilterSet):
price_min = RangeFilter(field_name='price', lookup_expr='gte')
price_max = RangeFilter(field_name='price', lookup_expr='lte')

class Meta:
model = Product
fields = ['price_min', 'price_max']

Solution

1. Step 1: Understand django-filter range filters

   RangeFilter allows filtering between min and max values on a single field.

2. Step 2: Evaluate options

   class ProductFilter(FilterSet): price = RangeFilter() class Meta: model = Product fields = ['price'] uses RangeFilter but it filters a range with a single field; however, RangeFilter does not split into min and max filters automatically. class ProductFilter(FilterSet): class Meta: model = Product fields = ['price__gte', 'price__lte'] uses invalid field names with double underscores in fields list, which is incorrect. class ProductFilter(FilterSet): price_min = NumberFilter(lookup_expr='gte') price_max = NumberFilter(lookup_expr='lte') class Meta: model = Product fields = ['price_min', 'price_max'] defines two NumberFilters with lookup expressions 'gte' and 'lte' on the same field 'price' and includes them correctly in fields list; this is the correct approach. class ProductFilter(FilterSet): price_min = RangeFilter(field_name='price', lookup_expr='gte') price_max = RangeFilter(field_name='price', lookup_expr='lte') class Meta: model = Product fields = ['price_min', 'price_max'] incorrectly uses RangeFilter twice with lookup_expr, which is not supported.

3. Final Answer:

   class ProductFilter(FilterSet): price_min = NumberFilter(lookup_expr='gte') price_max = NumberFilter(lookup_expr='lte') class Meta: model = Product fields = ['price_min', 'price_max'] -> Option C

4. Quick Check:

   Use NumberFilter with lookup_expr for min and max filtering [OK]

Hint: Use NumberFilter with lookup_expr for min and max [OK]

Common Mistakes:

• Using NumberFilter but listing wrong fields
• Trying to use RangeFilter with lookup_expr
• Specifying field names with double underscores in fields list