/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

18 votes105 views1 answer
Pandas read txt
Python
0 vote159 views1 answer
Learn basic facts about dataframe | dataframe info
Python
0 vote153 views1 answer
Celery beat command for django celery beat
Python
1 vote150 views1 answer
Python text to speech version 3
Python
16 votes185 views3 answers
Self keyword in python
Python
0 vote151 views1 answer
Dir template
Python
-4 votes191 views4 answers
Latest django version
Python Django
0 vote179 views2 answers
Howe to print all values and keysin d
Python
0 vote180 views1 answer
Python fibonacci sequence while loop
Python
0 vote154 views1 answer
AttributeError: 'tuple' object has no attribute 'reshape'
Python