/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 vote211 views1 answer
Staff user is not restricting permission in django
Python Django
0 vote279 views1 answer
Basic get method in class based view django
Python Django
0 vote218 views1 answer
Django template child data in nested loop
Python Django
0 vote182 views1 answer
How to add condition if null value in django orm
Python Django
0 vote216 views1 answer
How to insert a placeholder text in django modelform
Python Django
0 vote206 views1 answer
Get full detail inside of id in django rest framework many to many
Python Django
0 vote204 views1 answer
Django get all model fields
Python Django
25 votes410 views2 answers
Create new django app
Python Django
0 vote224 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python Django
2 votes259 views3 answers
Django queryset to list
Python Django