A QuerySet by aggregate field value

by

Oh, of course I forget about new aggregation support in Django and its annotate functionality.

So query may look like this:

Contest.objects.get(pk=id).image_set.annotate(score=Sum('vote__value')).order_by( 'score' )

More Related Contents:

  1. OperationalError: database is locked
  2. multiple databases and multiple models in django
  3. Django persistent database connection
  4. How do you join two tables on a foreign key field using django ORM?
  5. How to make/use a custom database function in Django
  6. How to see the raw SQL queries Django is running?
  7. How to move a model between two Django apps (Django 1.7)
  8. sqlite3.OperationalError: unable to open database file
  9. Race conditions in django
  10. What is your favorite solution for managing database migrations in django? [closed]
  11. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  12. Django: Increment blog entry view count by one. Is this efficient?
  13. django makemigrations and migrate on heroku server don’t create tables
  14. Django dynamic model fields
  15. Django filter queryset __in for *every* item in list
  16. How to execute a Python script from the Django shell?
  17. Django, creating a custom 500/404 error page
  18. Django: Redirect to previous page after login
  19. How do I force Django to ignore any caches and reload data?
  20. Django Rest Framework writable nested serializers
  21. How can I save my secret keys and password securely in my version control system?
  22. get request data in Django form
  23. Calling a REST API from django view
  24. Django – makemigrations – No changes detected
  25. How does the order of mixins affect the derived class?
  26. Django widget override template
  27. Run manage.py from AWS EB Linux instance
  28. How to perform filtering with a Django JSONField?
  29. Multiple lookup_fields for django rest framework
  30. Apache mod_wsgi error: Forbidden You don’t have permission to access / on this server

Leave a Comment