/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 vote116 views1 answer
Cite pandas python
Python
2 votes183 views2 answers
Python get file size in mb
Python
4 votes123 views3 answers
Python difference in time
Python
6 votes98 views1 answer
How to get username with userid discord.py
Python
1 vote135 views1 answer
Django get id of newly created object
Python Django
0 vote222 views1 answer
Create a thumbnail from video python
Python
0 vote126 views2 answers
Python seperate int into digit array
Python
0 vote107 views1 answer
Importando todo o pacote em python
Python
0 vote153 views1 answer
Raise 400 error python
Python
1 vote105 views1 answer
How to get pygame key
Python