/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

23 votes296 views3 answers
Django rest framework
Python Django
0 vote165 views1 answer
Unique mark boolean django model field
Python Django
0 vote187 views1 answer
Cannot cast type smallint to boolean django
Python Django
0 vote183 views1 answer
Merge two Querysets in Python Django while preserving Queryset methods
Python Django
0 vote209 views1 answer
IntegrityError import in django
Python Django
4 votes249 views2 answers
Django composite primary key
Python Django
0 vote180 views1 answer
Django ninja "schema"
Python Django
0 vote210 views1 answer
Fix the debug_mode = false django
Python Django
1 vote179 views3 answers
Django reverse lazy
Python Django
0 vote195 views2 answers
MultiValueDictKeyError django
Python Django