/Python/Django/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 vote381 views1 answer
How to add static files in django 3.2.9
Python Django
0 vote361 views1 answer
Django listview
Python Django
3 votes375 views6 answers
ImportError: Couldn't import Django. Are you sure it's installed and available on your PYTHONPATH environment variable? Did you forget to activate a virtual environment?
Python Django
1 vote353 views1 answer
Django form list option
Python Django
10 votes372 views2 answers
Django import settings
Python Django
19 votes387 views6 answers
Install Django in Windows
Python Django
0 vote385 views1 answer
Django swagger settings https
Python Django
0 vote319 views1 answer
Django iterating through objects
Python Django
0 vote397 views1 answer
Django include all columns admin show
Python Django
1 vote370 views1 answer
Using regex validators in django models
Python Django