Search and filter options in Django - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What is the output of this Django queryset filter?

Given the model Book with fields title and author, what does this queryset return?

Book.objects.filter(title__icontains='django')

A All books with titles exactly equal to 'django'

B All books with titles containing 'django' ignoring case

C All books with authors containing 'django' ignoring case

D All books with titles starting with 'django' ignoring case

💡 Hint

Look at the double underscore and the 'icontains' part in the filter.

The filter title__icontains='django' returns all books where the title contains the substring 'django' regardless of case.

📝 Syntax

intermediate

Which option correctly filters books published after 2020?

Assuming Book has a published_year integer field, which queryset filters books published after 2020?

A Book.objects.filter(published_year__gt=2020)

B Book.objects.filter(published_year>2020)

C Book.objects.filter(published_year__after=2020)

D Book.objects.filter(published_year__gte=2020)

💡 Hint

Look for the correct Django field lookup for greater than.

The correct lookup for greater than is __gt. Option A uses it correctly.

🔧 Debug

advanced

Why does this filter raise an error?

What error does this code raise?

Book.objects.filter(title__icontains)

A TypeError: filter() missing required positional argument

B SyntaxError: invalid syntax

C TypeError: filter() missing 1 required positional argument: 'kwargs'

D ValueError: Cannot use empty lookup value

💡 Hint

Check the filter method call and its arguments.

The filter method requires keyword arguments with values. Omitting the value causes a TypeError about missing arguments.

❓ state_output

advanced

How many items are in the queryset after this filter?

If the database has 5 books with titles: ['Django Basics', 'Advanced Django', 'Flask Guide', 'Django Tips', 'Python Tricks'], what is the count of Book.objects.filter(title__icontains='django')?

A 5

B 2

C 4

D 3

💡 Hint

Count titles containing 'django' ignoring case.

Titles containing 'django' are 'Django Basics', 'Advanced Django', and 'Django Tips' — total 3.

🧠 Conceptual

expert

Which option best describes the difference between filter() and exclude()?

In Django querysets, what is the main difference between filter() and exclude() methods?

A <code>filter()</code> returns items matching conditions; <code>exclude()</code> returns items not matching conditions

B <code>filter()</code> modifies the database; <code>exclude()</code> only reads data

C <code>filter()</code> returns a list; <code>exclude()</code> returns a dictionary

D <code>filter()</code> works only with strings; <code>exclude()</code> works only with numbers

💡 Hint

Think about what each method keeps or removes from the results.

filter() keeps items matching the condition, while exclude() removes those matching the condition.