Order by count of a ForeignKey field?

by 
from django.db.models import Count
top_users = User.objects.filter(problem_user=False) \
                .annotate(num_submissions=Count('submission')) \
                .order_by('-num_submissions')[:3]

You didn’t mention problem_user in your example model code, but I’ve left it in assuming that it is a BooleanField on User.

More Related Contents:

  1. (13: Permission denied) while connecting to upstream:[nginx]
  2. Django Cookies, how can I set them?
  3. Issue with ManyToMany Relationships not updating immediately after save
  4. Django: Populate user ID when saving a model
  5. How to revert the last migration?
  6. Get model’s fields in Django
  7. Can django’s auth_user.username be varchar(75)? How could that be done?
  8. Custom QuerySet and Manager without breaking DRY?
  9. Django: Query using contains each value in a list
  10. Changing Django settings at runtime
  11. How do you serialize a model instance in Django?
  12. How to get the list of the authenticated users?
  13. Django: How do I add arbitrary html attributes to input fields on a form?
  14. How to make email field unique in model User from contrib.auth in Django
  15. creating my own context processor in django
  16. Get list item dynamically in django templates
  17. Workflow frameworks for Django [closed]
  18. Select DISTINCT individual columns in django?
  19. Django ModelForm override widget
  20. Django Push HTTP Response to users [closed]
  21. django admin login suddenly demanding csrf token
  22. Django – Cascade deletion in ManyToManyRelation
  23. Django – filtering on foreign key properties
  24. CSRF with Django, React+Redux using Axios
  25. Django admin: How to display a field that is marked as editable=False’ in the model?
  26. django unit tests without a db
  27. Example of Django Class-Based DeleteView
  28. Django admin DoesNotExist at /admin/
  29. Django: permission denied when trying to access database after restore (migration)
  30. How can I upload and download files with graphene-django?

Leave a Comment