How to add a sortable count column to the Django admin of a model with a many-to-one relation?

by

I had the same issue (I cannot change my model’s manager to add slow annotations or joins). A combination of two of the answers here works. @Andre is really close, the Django Admin supports modifying the queryset for just the admin, so apply the same logic here and then user the admin_order_field attribute. You still need to add the new admin field to list_display, of course.

from django.db.models import Count

class EventAdmin(admin.ModelAdmin)
    list_display = (..., 'show_artist_count')

    def queryset(self, request):
    # def get_queryset(self, request):    for Django 1.6+
        qs = super(EventAdmin, self).queryset(request)
        return qs.annotate(artist_count=Count('artists'))

    def show_artist_count(self, inst):
        return inst.artist_count
    show_artist_count.admin_order_field = 'artist_count'

More Related Contents:

  1. Override default queryset in Django admin
  2. Tying in to Django Admin’s Model History
  3. Django “xxxxxx Object” display customization in admin action sidebar
  4. How to limit queryset/the records to view in Django admin site?
  5. How can I restrict Django’s GenericForeignKey to a list of models?
  6. Using Django auth UserAdmin for a custom user model
  7. Limit number of model instances to be created – django
  8. Password field in Django model
  9. Dynamic File Path in Django
  10. Issue with ManyToMany Relationships not updating immediately after save
  11. Django: Populate user ID when saving a model
  12. Get model’s fields in Django
  13. Can django’s auth_user.username be varchar(75)? How could that be done?
  14. Custom QuerySet and Manager without breaking DRY?
  15. Django: Query using contains each value in a list
  16. How do you serialize a model instance in Django?
  17. Django delete FileField
  18. How to make email field unique in model User from contrib.auth in Django
  19. Why does django’s prefetch_related() only work with all() and not filter()?
  20. Select DISTINCT individual columns in django?
  21. Django ModelForm override widget
  22. Django – filtering on foreign key properties
  23. How to display uploaded images in “Change List” page in Django Admin?
  24. Django admin: How to display a field that is marked as editable=False’ in the model?
  25. Django admin file upload with current model id
  26. one-to-many inline select with django admin
  27. How do I add a custom column with a hyperlink in the django admin interface?
  28. Django unique_together with nullable ForeignKey
  29. Resize fields in Django Admin
  30. django most efficient way to count same field values in a query

Leave a Comment