Admin ChangeList doesn't apply 'order_by' clause specified by ModelAdmin.queryset

[kyle.fox@…]

Overriding ModelAdmin.queryset to apply an explicit order_by clause doesn't work. Although it looks like it, the example shown won't order by '-birth_date'

class PersonAdmin(admin.ModelAdmin):
    list_display = ['name', 'birth_date']
    
    def queryset(self, request):
        return Person.objects.order_by('-birth_date')
        
admin.site.register(Person, PersonAdmin)

This patch changes ChangeList.get_ordering to respect any ordering clause that is present on the queryset.

[kyle.fox@…]

Patch for #10212 - Allows order_by in ModelAdmin.queryset

[Jacob]

Is there a reason not to just use ordering on the ModelAdmin?

[kyle.fox@…]

Yes -- I'm using ​django-mptt, which has a custom manager to calculates the ordering of objects according to hierarchy.

Currently, if you try to use a custom manager which defines it's own ordering, the admin *drops* that order by clause.

[oyvind]

I also hit this issue. Would be easier to solve with the patch in #9749.

[mzzzzc]

More general patch. Also allows multi-level ordering and ordering given in query_set.extra().

[Julien Phalip]

This is a dupe of #7309.