all() and filter() methods in Django - Step-by-Step Execution

Concept Flow - all() and filter() methods

Start QuerySet

↓

Call all()

→Return all objects

↓

Call filter(condition)

→Check each object

↓

Object matches?

↓

Include object

↓

Return filtered objects

The all() method returns all objects in the database table, while filter() checks each object against a condition and returns only those that match.

Execution Sample

Django

books = Book.objects.all()
filtered_books = Book.objects.filter(author='Alice')

Retrieve all Book objects, then retrieve only those where author is 'Alice'.

Execution Table

Step	Method Called	Condition	Objects Checked	Objects Returned
1	all()	None	All books in DB	All books in DB
2	filter(author='Alice')	author == 'Alice'	Book1(author='Alice'), Book2(author='Bob'), Book3(author='Alice')	Book1, Book3
3	filter(author='Alice')	author == 'Alice'	No more objects	Return filtered list

💡 All objects checked; filter returns only those matching the condition.

Variable Tracker

Variable	Start	After all()	After filter()
books	undefined	All Book objects	All Book objects
filtered_books	undefined	undefined	Books with author='Alice'

Key Moments - 2 Insights

Why does all() return more objects than filter()?

all() returns every object without checking conditions, as shown in execution_table step 1, while filter() checks each object and returns only those matching the condition (step 2).

Does filter() modify the original queryset?

No, filter() returns a new queryset with matching objects, it does not change the original queryset, as seen by 'books' remaining all objects after filter() in variable_tracker.

Visual Quiz - 3 Questions

Look at the execution_table at step 2, how many objects match the filter condition?

A 1

B 3

C 2

D 0

💡 Hint

Check the 'Objects Returned' column at step 2 in execution_table.

According to variable_tracker, what does 'books' contain after calling all()?

A Only filtered books

B All Book objects

C No objects

D Books with author='Alice'

💡 Hint

Look at the 'After all()' column for 'books' in variable_tracker.

If filter() condition was changed to author='Bob', how would the 'Objects Returned' at step 2 change?

A Return only Book2

B Return Book1 and Book3

C Return all books

D Return no books

💡 Hint

Refer to execution_table step 2 where filtering is based on author name.

Concept Snapshot

all(): Returns all objects from the database table.
filter(condition): Returns objects matching the given condition.
all() returns everything; filter() checks each object.
Neither modifies the database, both return QuerySets.
Use filter() to narrow down results by criteria.

Full Transcript

In Django, the all() method fetches every object from the database table without any filtering. The filter() method takes a condition and returns only those objects that meet it. For example, calling all() on a Book model returns all books, while filter(author='Alice') returns only books written by Alice. The execution flow starts with the full set of objects, then filter checks each object against the condition, including only those that match. Variables like 'books' hold all objects after all(), and 'filtered_books' hold only matching objects after filter(). This helps you get exactly the data you want from the database.