Django QuerySet Order By

Key order_by() Features

# A to Z, 0 to 9
books = Book.objects.order_by('price')

# Z to A, 9 to 0
books = Book.objects.order_by('-price')

# Sort by author, then price
books = Book.objects.order_by(
    'author', 'price'
)

# Random order
books = Book.objects.order_by('?')

🔹 Basic Ordering

Use order_by() to sort your QuerySet by any field. By default, sorting is in ascending order (A-Z, 0-9). This is useful for displaying data in a logical sequence.

# models.py
from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=200)
    author = models.CharField(max_length=100)
    price = models.DecimalField(max_digits=6, decimal_places=2)
    published_date = models.DateField()
    rating = models.FloatField()

# views.py
from myapp.models import Book

# Order by title (A to Z)
books = Book.objects.order_by('title')

# Order by price (lowest to highest)
books = Book.objects.order_by('price')

# Order by date (oldest to newest)
books = Book.objects.order_by('published_date')

for book in books:
    print(f"{book.title} - ${book.price}")

🔹 Descending Order

Add a minus sign (-) before the field name to sort in descending order (Z-A, 9-0). This is perfect for showing newest items first or highest values at the top.

from myapp.models import Book

# Order by price (highest to lowest)
expensive_first = Book.objects.order_by('-price')

# Order by date (newest to oldest)
newest_first = Book.objects.order_by('-published_date')

# Order by rating (highest to lowest)
top_rated = Book.objects.order_by('-rating')

# Order by title (Z to A)
reverse_alpha = Book.objects.order_by('-title')

for book in expensive_first[:3]:
    print(f"{book.title} - ${book.price}")

🔹 Multiple Field Ordering

Pass multiple field names to order_by() to create complex sorting. Django sorts by the first field, then uses subsequent fields as tiebreakers when values are equal.

from myapp.models import Book

# Order by author, then by price
books = Book.objects.order_by('author', 'price')

# Order by author (A-Z), then price (high to low)
books = Book.objects.order_by('author', '-price')

# Order by rating (high to low), then date (new to old)
books = Book.objects.order_by('-rating', '-published_date')

# Complex ordering
books = Book.objects.order_by('author', '-rating', 'title')

for book in books:
    print(f"{book.author} - {book.title} (${book.price})")

🔹 Combining with filter()

You can chain order_by() with filter() and other QuerySet methods to both filter and sort your results. The order of chaining doesn't matter for the final result.

from myapp.models import Book

# Filter then order
published_books = Book.objects.filter(
    published=True
).order_by('-published_date')

# Order then filter (same result)
published_books = Book.objects.order_by(
    '-published_date'
).filter(published=True)

# Complex query
affordable_top_rated = Book.objects.filter(
    price__lt=50,
    rating__gte=4.0
).order_by('-rating', 'price')

for book in affordable_top_rated:
    print(f"{book.title} - Rating: {book.rating} - ${book.price}")

🔹 Random Ordering

Use order_by('?') to randomize your QuerySet results. This is useful for features like "random book of the day" or shuffling content displays.

from myapp.models import Book

# Get books in random order
random_books = Book.objects.order_by('?')

# Get 3 random books
random_three = Book.objects.order_by('?')[:3]

# Random published books
random_published = Book.objects.filter(
    published=True
).order_by('?')

for book in random_three:
    print(book.title)

🔹 Reversing Order

Use the reverse() method to flip the order of an already ordered QuerySet. This is more efficient than re-ordering with different parameters.

from myapp.models import Book

# Order by price ascending
books = Book.objects.order_by('price')

# Reverse to descending
books_reversed = books.reverse()

# Can also chain directly
books = Book.objects.order_by('title').reverse()

# Reverse complex ordering
books = Book.objects.order_by(
    'author', 'price'
).reverse()

for book in books_reversed[:3]:
    print(f"{book.title} - ${book.price}")