Good ways to sort a queryset? – Django

by

What about

import operator

auths = Author.objects.order_by('-score')[:30]
ordered = sorted(auths, key=operator.attrgetter('last_name'))

In Django 1.4 and newer you can order by providing multiple fields.
Reference: https://docs.djangoproject.com/en/dev/ref/models/querysets/#order-by

order_by(*fields)

By default, results returned by a QuerySet are ordered by the ordering tuple given by the ordering option in the model’s Meta. You can override this on a per-QuerySet basis by using the order_by method.

Example:

ordered_authors = Author.objects.order_by('-score', 'last_name')[:30]

The result above will be ordered by score descending, then by last_name ascending. The negative sign in front of "-score" indicates descending order. Ascending order is implied.

More Related Contents:

  1. Django dynamic model fields
  2. How do I filter query objects by date range in Django?
  3. Django set default form values
  4. How to create an object for a Django model with a many to many field?
  5. django abstract models versus regular inheritance
  6. Django post_save() signal implementation
  7. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  8. What is the most efficient way to store a list in the Django models?
  9. Get all related Django model objects
  10. difference between filter with multiple arguments and chain filter in django
  11. LEFT JOIN Django ORM
  12. Django Rest Framework and JSONField
  13. django.db.migrations.exceptions.InconsistentMigrationHistory
  14. Django Blob Model Field
  15. Django Many-to-Many (m2m) Relation to same model
  16. Writing a __init__ function to be used in django model
  17. How to change the file name of an uploaded file in Django?
  18. Easiest way to rename a model using Django/South?
  19. Customize/remove Django select box blank option
  20. Duplicating model instances and their related objects in Django / Algorithm for recusrively duplicating an object
  21. Resize fields in Django Admin
  22. Get the latest record with filter in Django
  23. Django DoesNotExist
  24. Generic many-to-many relationships
  25. python_2_unicode_compatible error
  26. How to validate uniqueness constraint across foreign key (django)
  27. How to store a dictionary on a Django Model?
  28. How to properly use the “choices” field option in Django
  29. update django database to reflect changes in existing models
  30. Django admin – inline inlines (or, three model editing at once)

Leave a Comment