/Python/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

0 vote278 views1 answer
Dip programming language
Python
8 votes314 views2 answers
Python requests header
Python
19 votes358 views6 answers
Add item to python list
Python
0 vote378 views1 answer
Jupyterlab interactive plot
Python
0 vote363 views1 answer
Opencv houghlines only horizontal
Python
0 vote340 views1 answer
Access dynamicall to name attribute python
Python
0 vote319 views1 answer
Python3 subprocess getoutput
Python
0 vote375 views1 answer
Django from
Python Django
2 votes369 views1 answer
And condition with or in django
Python Django
2 votes372 views2 answers
How to make a clock in python 3
Python