/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 vote101 views1 answer
Python program to demonstrate scoping
Python
0 vote114 views1 answer
Dictionnaire
Python
0 vote119 views1 answer
How to deploy to heroku djangorest framework app
Python
0 vote119 views1 answer
Crear matriz python for
Python
0 vote115 views1 answer
OneHotEncoder(categorical_features=
Python
0 vote132 views1 answer
Print dataframe row horizontally
Python
0 vote121 views1 answer
Plt.hist using bins
Python
0 vote121 views1 answer
Split a pd dataframe
Python
22 votes109 views6 answers
What is palindrome number in python
Python
3 votes129 views6 answers
Fizz buzz python
Python