Django. How to sort queryset by custom method?

Question

Django

There is a product model, with a custom discount_price method that calculates the discounted price of the product.
The calculation is not trivial and is not done in one request.
I can not find a good way to sort and make selections at this price.
Who faced a similar problem, tell me where to dig.

Answer 1

There is no normal way to sort "by method", leaving the selection as a QuerySet. You can transfer the logic to SQL and sort there.

Answer 2

Entry.objects.order_by('discount_price')

Answer 3

If, for example, you need to sort by another field of another table, you make an annotation, and you can filter or sort by that lookup. Saved me a lot at the time.