Sorting a Django QuerySet by a property (not a field) of the Model

Use QuerySet.extra() along with CASE ... END to define a new field, and sort on that.

Stops.objects.extra(select={'cost': 'CASE WHEN price=0 THEN 0 '
  'WHEN type=:EXPRESS_STOP THEN price/2 WHEN type=:LOCAL_STOP THEN price*2'},
  order_by=['cost'])

That, or cast the QuerySet returned from the rest to a list, then use L.sort(key=operator.attrgetter('cost')) on it.

Related Contents:

  1. django template system, calling a function inside a model
  2. Django: Display Choice Value
  3. matching query does not exist Error in Django
  4. Django dynamic model fields
  5. What is a “slug” in Django?
  6. Django set default form values
  7. What’s the difference between select_related and prefetch_related in Django ORM?
  8. How to access a dictionary element in a Django template?
  9. Programmatically saving image to Django ImageField
  10. Django FileField with upload_to determined at runtime
  11. Performing a getattr() style lookup in a django template
  12. Django, creating a custom 500/404 error page
  13. django html template can’t find static css and js files
  14. Django TemplateDoesNotExist?
  15. Django rest framework serializing many to many field
  16. How do I create a slug in Django?
  17. Why doesn’t django’s model.save() call full_clean()?
  18. Django post_save() signal implementation
  19. Django Aggregation: Summation of Multiplication of two fields
  20. How to create an object for a Django model with a many to many field?
  21. How do I restrict foreign keys choices to related objects only in django
  22. How to get the domain name of my site within a Django template?
  23. Get all related Django model objects
  24. Writing a __init__ function to be used in django model
  25. Django Rest Framework and JSONField
  26. django.db.migrations.exceptions.InconsistentMigrationHistory
  27. How to store a dictionary on a Django Model?
  28. Using a Django custom model method property in order_by()
  29. How to change the file name of an uploaded file in Django?
  30. Is this the way to validate Django model fields?
  31. Nested inlines in the Django admin?
  32. How to have a Python script for a Django app that accesses models without using the manage.py shell?
  33. Django Unique Together (with foreign keys)
  34. LEFT JOIN Django ORM
  35. Any way to make {% extends ‘…’ %} conditional? – Django
  36. How to make Django slugify work properly with Unicode strings?
  37. Django: Why do some model fields clash with each other?
  38. How do I perform query filtering in django templates
  39. How do I make an auto increment integer field in Django?
  40. Django Blob Model Field
  41. Split models.py into several files
  42. Django admin file upload with current model id
  43. How to access the user profile in a Django template?
  44. Access request in django custom template tags
  45. Django: How to create a model dynamically just for testing
  46. Django admin – inline inlines (or, three model editing at once)
  47. Override a form in Django admin
  48. “{% extends %}” vs “{% include %}” in Django Templates
  49. What is the best way to access stored procedures in Django’s ORM
  50. QuerySet, Object has no attribute id – Django

Leave a Comment