Django admin: how to sort by one of the custom list_display fields that has no database field

by

I loved Greg’s solution to this problem, but I’d like to point that you can do the same thing directly in the admin:

from django.db import models

class CustomerAdmin(admin.ModelAdmin):
    list_display = ('number_of_orders',)

    def get_queryset(self, request):
    # def queryset(self, request): # For Django <1.6
        qs = super(CustomerAdmin, self).get_queryset(request)
        # qs = super(CustomerAdmin, self).queryset(request) # For Django <1.6
        qs = qs.annotate(models.Count('order'))
        return qs

    def number_of_orders(self, obj):
        return obj.order__count
    number_of_orders.admin_order_field = 'order__count'

This way you only annotate inside the admin interface. Not with every query that you do.

More Related Contents:

  1. Django Admin Show Image from Imagefield
  2. Issue with ManyToMany Relationships not updating immediately after save
  3. Override default queryset in Django admin
  4. Overriding admin css in django
  5. Tying in to Django Admin’s Model History
  6. Django: How to get current user in admin forms?
  7. Django “xxxxxx Object” display customization in admin action sidebar
  8. Django: accessing the model instance from within ModelAdmin?
  9. How to limit queryset/the records to view in Django admin site?
  10. Django: ordering numerical value with order_by
  11. How can I restrict Django’s GenericForeignKey to a list of models?
  12. Using Django auth UserAdmin for a custom user model
  13. Django admin: How to display a field that is marked as editable=False’ in the model?
  14. Django admin, hide a model
  15. Redirect on admin Save
  16. How do I add a custom column with a hyperlink in the django admin interface?
  17. UnicodeEncodeError: ‘ascii’ codec can’t encode character
  18. Django Admin – Overriding the widget of a custom form field
  19. Limit number of model instances to be created – django
  20. Getting Django admin url for an object
  21. Readonly models in Django admin interface?
  22. Creating Custom Filters for list_filter in Django Admin
  23. Can I make list_filter in django admin to only show referenced ForeignKeys?
  24. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  25. Password field in Django model
  26. Extending Django Admin Templates – altering change list
  27. Django: access the parent instance from the Inline model admin
  28. How to have 2 different admin sites in a Django project?
  29. django: how to access current request user in ModelForm?
  30. Django query case-insensitive list match

Leave a Comment