/Python/Django/Django order by foreign key count

Django order by foreign key count

# order_by count of foreign key relation
from django.db.models import Count
top_users = User.objects.filter(problem_user=False) \
                .annotate(num_submissions=Count('submission')) \ # adds column "num_submissions" in "top_users"
                .order_by('-num_submissions')

Source: stackoverflow.com

Similar codes

25 votes456 views2 answers
Django create app command
Python Django
0 vote331 views1 answer
Django default template location
Python Django
0 vote367 views1 answer
Setting up a django prostgress project
Python Django
0 vote349 views1 answer
Django auto complete light styling
Python Django
8 votes315 views3 answers
Django sort queryset
Python Django
0 vote314 views1 answer
Django model meta ordering multiple ordering
Python Django
1 vote334 views1 answer
Filter foreign fileds django_filters
Python Django
2 votes352 views1 answer
Pass in queryset as filter django
Python Django
0 vote342 views1 answer
Get ip address in django
Python Django
0 vote332 views2 answers
Django run manage.py from python
Python Django