Filtering with django-filter - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import the django-filter package.

Django

import [1]

Drag options to blanks, or click blank then click option'

Adjango_filters

Bdjango-filter

Cfilter_django

Ddjangofilter

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash instead of underscore in the import.

Trying to import 'filter_django' which does not exist.

The correct import for django-filter is django_filters. This is the package name used in Python code.

2fill in blank

medium

Complete the code to create a filter class for a model named Product.

Django

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

Drag options to blanks, or click blank then click option'

Afilters

Bdjango_filter

Cfilter

Ddjango_filters

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'filters.FilterSet' instead of 'django_filters.FilterSet'.

Misspelling the package name.

The filter class should inherit from django_filters.FilterSet to work properly.

3fill in blank

hard

Fix the error in the view to apply the filter to the queryset.

Django

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

Drag options to blanks, or click blank then click option'

Afilterset

Bfilter

Cfilters

Dfilterset_qs

Attempts:

3 left

💡 Hint

Common Mistakes

Passing filterset_qs which is not defined here.

Using a wrong context key that the template does not expect.

The context key should be filter or any name you choose, but commonly filter is used to pass the filter object to the template.

4fill in blank

hard

Fill both blanks to filter products with price greater than 20 and order by name.

Django

filtered_products = Product.objects.filter(price__[1]=20).order_by([2])

Drag options to blanks, or click blank then click option'

Agt

Blt

C'name'

D'-name'

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'lt' which means less than.

Ordering by '-name' which sorts descending.

Use gt to filter prices greater than 20 and order by 'name' ascending.

5fill in blank

hard

Fill all three blanks to create a filter that filters by category 'Books', price less than 50, and orders by descending price.

Django

filtered = Product.objects.filter(category=[1], price__[2]=[3]).order_by('-price')

Drag options to blanks, or click blank then click option'

A'Books'

Blt

C50

D'Books & More'

Attempts:

3 left

💡 Hint

Common Mistakes

Using category without quotes.

Using 'gt' instead of 'lt' for price.

Using wrong price value.

Filter category by the string 'Books', price less than 50 using 'lt', and order descending by price.

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