/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

2 votes125 views1 answer
Django queryset get all distinct
Python Django
0 vote73 views1 answer
Django creat app return _bootstrap._gcd_import
Python Django
0 vote137 views1 answer
Django strptime
Python Django
1 vote159 views4 answers
Django query or condition for query parameters
Python Django
6 votes72 views5 answers
Manage.py", line 12, in main raise importerror( 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
10 votes145 views1 answer
Django new static files directory
Python Django
0 vote119 views1 answer
Django queryset last 10
Python Django
0 vote129 views1 answer
Default ordering django
Python Django
2 votes134 views1 answer
Import validation error in django
Python Django
-1 vote133 views1 answer
Django custom primary key field
Python Django