How to use multiple order_by in single Django query with conditions based on field values

Question

How can I make order_by fields in a single query dependent on field values?

e.g.,

• if field status==10 then sort ascending
• if field status==20 then sort descending

Answer 1

You can use conditions in your order_by like this:

from django.db.models import Case, When

Model.objects.order_by(
    Case(When(status='10', then='some_field')).asc(),
    Case(When(status='20', then='some_field')).desc())