Ordering and slicing querysets in Django

Introduction

Ordering and slicing help you get data from the database in the order and amount you want. This makes your app faster and easier to use.

When you want to show a list of items sorted by date or name.

When you need only the first few results, like top 5 products.

When you want to skip some items and get the next set, like pages in a list.

When you want to display data in a specific order, such as newest first.

When you want to limit the data sent to the user to improve speed.

Syntax

Django

Model.objects.order_by('field_name')[start:end]

Use order_by() to sort results by one or more fields.

Use slicing [start:end] to get a subset of results, like a list slice.

Examples

Get all books ordered alphabetically by title.

Django

Book.objects.order_by('title')

Get all books ordered by published date, newest first (descending).

Django

Book.objects.order_by('-published_date')

Get the first 5 books ordered by author name.

Django

Book.objects.order_by('author')[0:5]

Get books from 11th to 20th without ordering (default order).

Django

Book.objects.all()[10:20]

Sample Program

This example shows how to get books sorted by newest published date first, then take only the first two books from that list. It prints their title, author, and date.

Django

from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=100)
    author = models.CharField(max_length=100)
    published_date = models.DateField()

# Imagine we have these books in the database:
# 1. Title: 'A Tale of Two Cities', Author: 'Charles Dickens', Date: 1859-04-30
# 2. Title: 'Moby Dick', Author: 'Herman Melville', Date: 1851-10-18
# 3. Title: 'Pride and Prejudice', Author: 'Jane Austen', Date: 1813-01-28

# Get books ordered by published_date descending (newest first)
books = Book.objects.order_by('-published_date')

# Get the first 2 books from this ordered list
top_two_books = books[:2]

for book in top_two_books:
    print(f"{book.title} by {book.author} ({book.published_date})")

Important Notes

Slicing querysets uses zero-based indexing like Python lists.

Ordering by multiple fields is possible: .order_by('field1', '-field2').

Negative sign - before field name means descending order.

Summary

Use order_by() to sort your data by one or more fields.

Use slicing [start:end] to get only part of the data.

Ordering and slicing together help you show data in the right order and amount.

Practice

1. What does the Django queryset method order_by('name') do?

easy

A. Groups the queryset results by the 'name' field.

B. Filters the queryset to only include objects with the name 'order_by'.

C. Sorts the queryset results by the 'name' field in ascending order.

D. Deletes all objects that have a 'name' field.

Solution

1. Step 1: Understand the order_by() method

   The order_by() method sorts the queryset results based on the given field(s).

2. Step 2: Apply order_by('name')

   This sorts the results by the 'name' field in ascending order by default.

3. Final Answer:

   Sorts the queryset results by the 'name' field in ascending order. -> Option C

4. Quick Check:

   order_by('name') = sorted by name ascending [OK]

Hint: Remember: order_by sorts, does not filter or delete [OK]

Common Mistakes:

• Confusing order_by with filter
• Thinking order_by deletes data
• Assuming order_by groups data

2. Which of the following is the correct syntax to get the first 5 objects ordered by 'created_at' descending?

easy

A. Model.objects.order_by('-created_at')[:5]

B. Model.objects[:5].order_by('-created_at')

C. Model.objects.order_by('created_at')[:5]

D. Model.objects.order_by('created_at')[-5:]

Solution

1. Step 1: Use order_by('-created_at') for descending order

   Prefixing the field with '-' sorts descending.

2. Step 2: Slice the queryset with [:5] to get first 5 results

   Slicing before evaluation limits results to first 5.

3. Final Answer:

   Model.objects.order_by('-created_at')[:5] -> Option A

4. Quick Check:

   Descending order + first 5 = order_by('-field')[:5] [OK]

Hint: Use '-' before field for descending order, slice after ordering [OK]

Common Mistakes:

• Slicing before ordering (wrong order)
• Missing '-' for descending order
• Using negative slice like [-5:] incorrectly

3. Given the queryset qs = Model.objects.order_by('age')[2:5], what will list(qs) return if the ages in the database are [20, 25, 30, 35, 40, 45]?

medium

A. [25, 30, 35]

B. [30, 35, 40]

C. [35, 40, 45]

D. [20, 25, 30]

Solution

1. Step 1: Order the ages ascending

   Ordering by 'age' gives [20, 25, 30, 35, 40, 45].

2. Step 2: Slice from index 2 to 5 (excluding 5)

   Indexes 2, 3, 4 correspond to ages 30, 35, 40.

3. Final Answer:

   [30, 35, 40] -> Option B

4. Quick Check:

   order_by + slice = [30, 35, 40] [OK]

Hint: Remember slicing excludes the end index [OK]

Common Mistakes:

• Including the end index in slice
• Mixing up ascending and descending order
• Using wrong slice indexes

4. What is wrong with this queryset code?

qs = Model.objects[:5].order_by('name')

medium

A. You cannot slice a queryset before ordering; slicing must come after ordering.

B. The queryset must be filtered before ordering.

C. The order_by method requires a list, not a string.

D. Slicing with [:5] returns a list, so order_by cannot be called after.

Solution

1. Step 1: Understand queryset slicing returns a list

   Slicing a queryset like Model.objects[:5] evaluates it and returns a list, not a queryset.

2. Step 2: Calling order_by on a list causes error

   Lists do not have order_by method, so this code raises an error.

3. Final Answer:

   Slicing with [:5] returns a list, so order_by cannot be called after. -> Option D

4. Quick Check:

   Slice first = list, no order_by after [OK]

Hint: Always order before slicing to keep queryset chainable [OK]

Common Mistakes:

• Slicing before ordering
• Thinking order_by accepts lists
• Confusing filter and order_by order

5. You want to get the 3rd to 7th newest entries from a model ordered by 'published_date' descending. Which queryset code is correct?

hard

A. Model.objects.order_by('-published_date')[2:7]

B. Model.objects.order_by('published_date')[3:8]

C. Model.objects[2:7].order_by('-published_date')

D. Model.objects.order_by('-published_date')[3:8]

Solution

1. Step 1: Order by 'published_date' descending

   Use order_by('-published_date') to get newest first.

2. Step 2: Slice from index 2 to 7 to get 3rd to 7th entries

   Slicing [2:7] gets items at indexes 2,3,4,5,6 (5 items total).

3. Final Answer:

   Model.objects.order_by('-published_date')[2:7] -> Option A

4. Quick Check:

   Descending order + slice 2:7 = 3rd to 7th newest [OK]

Hint: Order descending first, then slice with zero-based indexes [OK]

Common Mistakes:

• Using ascending order instead of descending
• Slicing with wrong indexes (off by one)
• Slicing before ordering