/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 vote304 views2 answers
Where should favicon.ico be placed in flask app
Python
0 vote302 views1 answer
Como inserir regras usg pelo prompt
Python
0 vote330 views1 answer
Use ipython magic in script
Python
32 votes299 views3 answers
Dotenv python
Python
1 vote302 views1 answer
How to convert an image to ascii art using python
Python
0 vote317 views1 answer
Python yield from
Python
0 vote304 views1 answer
Applies the f function to all Row
Python
0 vote293 views1 answer
In python how to end the code after 10 input
Python
0 vote350 views3 answers
How to create a User and User profile in django rest framework
Python
4 votes279 views5 answers
Module 'datetime' has no attribute 'now' django
Python