How to group by AND aggregate with Django

by

Try this:

Rating.objects.filter(attribute__in=attributes) \
    .values('location') \
    .annotate(score = Sum('score')) \
    .order_by('-score')

More Related Contents:

  1. Django: Group by date (day, month, year)
  2. Django 1.11 Annotating a Subquery Aggregate
  3. How to set a Django model field’s default value to a function call / callable (e.g., a date relative to the time of model object creation)
  4. How to use permission_required decorators on django class-based views
  5. Django Admin Show Image from Imagefield
  6. Django: Get model from string?
  7. Django: Get list of model fields?
  8. How do I get Django Admin to delete files when I remove an object from the database/model?
  9. What’s the recommended approach to resetting migration history using Django South?
  10. How do I add multiple arguments to my custom template filter in a django template?
  11. How to automatically login a user after registration in django
  12. Django model instances primary keys do not reset to 1 after all instances are deleted
  13. How to fetch static CSS files with django on IIS?
  14. Check permission inside a template in Django
  15. 405 POST method not allowed
  16. How to remove all relations from manytomany?
  17. How to access outermost forloop.counter with nested for loops in Django templates?
  18. How to get URL of current page, including parameters, in a template?
  19. Django: show/log ORM sql calls from python shell
  20. Can Django automatically create a related one-to-one model?
  21. Cannot find command ‘git’ – windows
  22. Make Django forms use comma as decimal separator
  23. Django – show loading message during long processing
  24. Django model with 2 foreign keys from the same table
  25. How to add Check Constraints for Django Model fields?
  26. Django templates folders
  27. Django Programming error column does not exist even after running migrations
  28. Django – Static file not found
  29. Different db for testing in Django?
  30. django: how to access current request user in ModelForm?

Leave a Comment