django order by foreign key count

Solutions on MaxInterview for django order by foreign key count by the best coders in the world

showing results for - "django order by foreign key count"

1# order_by count of foreign key relation
2from django.db.models import Count
3top_users = User.objects.filter(problem_user=False) \
4                .annotate(num_submissions=Count('submission')) \ # adds column "num_submissions" in "top_users"
5                .order_by('-num_submissions')
6

similar questions

foreginkey django django foreign key to same django queryset count iterate over dictionary django list display django foreign key foreign key django createview select realted for foreign key table in django django insert data into database foreign key view py select children of an object with foreignkey in django 3f foreignkey as users from a user group django python collections counter sort by key how to filter queryset with foreign key in django django foreign key field django models add foreign key how to set a foreign key field value to current user django rest framework add to manytomany key django stackoverflow django create foreignkey from id

queries leading to this page

django count reverse foreign key order by foreign key django django order by foreign key how to get all foreign key field count django django order foreign keys django order by foreign key value django query order by count foreign key django order by foreign key count