/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 vote162 views1 answer
How to check if all values in list are equal python
Python
3 votes152 views2 answers
Import class from another file python
Python
1 vote164 views1 answer
Cannot import name 'candlestick2_ohlc
Python
0 vote147 views1 answer
Django edit model without loading from db
Python
3 votes187 views1 answer
Python add legend title
Python
0 vote132 views1 answer
Alpaca examples
Python
2 votes133 views2 answers
Check string similarity python
Python
0 vote134 views1 answer
Inherit init method
Python
0 vote143 views1 answer
Countvectorizer remove stop words
Python
40 votes145 views2 answers
Sorting values in dictionary in python
Python