/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 vote180 views1 answer
Python - How To Check if a String Contains Word
Python
20 votes225 views6 answers
Python append to list
Python
2 votes183 views1 answer
OPENCV GET CONTOURS
Python
6 votes193 views2 answers
Tkinter template
Python
1 vote262 views1 answer
Updating many to many field in django using pk
Python Django
7 votes183 views2 answers
How to add a image in tkinter
Python
17 votes182 views2 answers
Make selenium headless python
Python
0 vote827 views1 answer
X = y < z and z > y or y > z and z < y python
Python
-1 vote176 views1 answer
How to print multiple integers in python in different line
Python
0 vote219 views2 answers
Nameerror name 'defaultdict' is not defined
Python