Search and ordering in Django - Step-by-Step Execution

Concept Flow - Search and ordering

User sends request with search and order params

↓

Django View receives request

↓

Extract search query and order field

↓

Filter queryset by search query

↓

Order queryset by order field

↓

Return filtered and ordered results to user

The flow shows how a Django view takes search and order parameters from a user request, filters and orders the data accordingly, then returns the results.

Execution Sample

Django

def product_list(request):
    q = request.GET.get('q', '')
    order = request.GET.get('order', 'name')
    products = Product.objects.filter(name__icontains=q).order_by(order)
    return render(request, 'products.html', {'products': products})

This Django view filters products by a search query and orders them by a specified field, then renders the results.

Execution Table

Step	Action	Search Query (q)	Order Field	Queryset Filter	Queryset Order	Result Count
1	Receive request			No filter	Default order by 'name'	All products
2	Extract q and order	phone	price	Filter name contains 'phone'	Order by 'price'	Filtered products
3	Execute queryset	phone	price	Applied filter	Applied order	10 products found
4	Render response	phone	price	Filtered	Ordered	10 products shown
5	Request with empty q		name	No filter	Order by 'name'	All products
6	Execute queryset		name	No filter	Applied order	50 products found
7	Render response		name	No filter	Ordered	50 products shown
8	Request with q='book', order='-created'	book	-created	Filter name contains 'book'	Order by '-created'	Filtered products
9	Execute queryset	book	-created	Applied filter	Applied order	5 products found
10	Render response	book	-created	Filtered	Ordered	5 products shown
11	Exit					No more requests

💡 No more requests to process, execution ends.

Variable Tracker

Variable	Start	After Step 2	After Step 5	After Step 8	Final
q	'' (empty)	'phone'	'' (empty)	'book'	'book'
order	'name'	'price'	'name'	'-created'	'-created'
products queryset count	50 (all)	10 (filtered)	50 (all)	5 (filtered)	5 (filtered)

Key Moments - 3 Insights

Why does the queryset change when 'q' is empty?

When 'q' is empty (see step 5), the filter 'name__icontains=q' matches all products, so the queryset is not filtered and returns all products.

What happens if the 'order' parameter is missing?

If 'order' is missing, the code uses the default 'name' field to order the queryset, as shown in step 1 and 5.

How does the order '-created' affect the results?

The '-' before 'created' means descending order by creation date, so newest products appear first, as in step 8 and 9.

Visual Quiz - 3 Questions

Look at the execution table at step 3. What is the search query 'q' value?

A '' (empty)

B 'phone'

C 'book'

D 'price'

💡 Hint

Check the 'Search Query (q)' column at step 3 in the execution_table.

At which step does the queryset get ordered by the default 'name' field?

A Step 2

B Step 8

C Step 5

D Step 9

💡 Hint

Look at the 'Order Field' column in the execution_table for the default 'name' value.

If the search query 'q' changes to 'tablet', how would the 'products queryset count' change in variable_tracker?

A It would be zero if no products match 'tablet'

B It would stay the same as for 'phone'

C It would be 50 products

D It would order by 'price'

💡 Hint

Filtering depends on 'q' matching product names, see variable_tracker and execution_table filtering steps.

Concept Snapshot

Django Search and Ordering:
- Extract search query and order field from request.GET
- Filter queryset with filter(name__icontains=q)
- Order queryset with order_by(order)
- Default order if none provided
- Return filtered and ordered results
- Handles empty search gracefully

Full Transcript

This visual execution trace shows how a Django view handles search and ordering. The user sends a request with optional search query 'q' and order field 'order'. The view extracts these parameters, filters the Product queryset by checking if the product name contains 'q', and orders the results by the 'order' field. If 'q' is empty, no filtering is applied. If 'order' is missing, a default ordering by 'name' is used. The execution table tracks each step, showing how the queryset changes and how many products match. The variable tracker shows how 'q', 'order', and the queryset count change over time. Key moments clarify common confusions about empty queries and ordering syntax. The quiz tests understanding of these steps. This approach helps beginners see how search and ordering work step-by-step in Django.