/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 vote284 views1 answer
Software developer tools list
Python
11 votes282 views2 answers
Python all permutations of a string
Python
0 vote290 views1 answer
Aritmetics to a value in a dict python
Python
140 votes312 views3 answers
Windows python pip upgrade
Python
1 vote277 views2 answers
Read header of csv file python
Python
3 votes302 views1 answer
Load pandas from text
Python
0 vote281 views1 answer
Thicker lines in colorbar for contourplot
Python
17 votes271 views6 answers
Python matplotlib
Python
4 votes273 views1 answer
Python format only 1 decimal place
Python
0 vote271 views1 answer
Colorbar remove tick lines and border
Python