/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 vote173 views1 answer
Exec to return a value python
Python
0 vote231 views1 answer
How to pass primary key to url django
Python Django
0 vote167 views1 answer
Python search list by value
Python
0 vote191 views1 answer
List comprehensions with dates
Python
4 votes245 views1 answer
Remove all pycache files
Python
0 vote186 views1 answer
Check substring frequency in a text python
Python
15 votes194 views6 answers
Python list max value
Python
0 vote175 views1 answer
TypeError: can only concatenate str (not "method") to str
Python
0 vote195 views1 answer
Tensorflow Bert implementation
Python
0 vote169 views1 answer
Select numbers from a list with a limit python
Python