Django - sort records by custom column

Question

I can't figure out how to make admin able to sort records using custom column - hours_to_deadline (when they clicks on the column header). In my case, it's timedelta.

class JobAdmin(SuperModelAdmin):
    ...
    list_display = ['id', 'identificator', 'created', 'invoice__estimated_delivery','hours_to_deadline','customer__username', 'language_from__name', 'language_to__name',
                    'delivery__status', 'confirmed', 'approved', 'invoice__final_price']
    ...


    def hours_to_deadline(self,obj):
        try:
            return (obj.invoice.estimated_delivery - now())
        except:
            return None

I found this solution: https://stackoverflow.com/a/15935591/3371056

But in my case, I can't just do sum or something similar.

Do you know what to do?

score 1 · Answer 1 · answered Jan 26 '17 at 20:43

You cannot order by a field that is not an actual database field, because all the sorting is done on the database level. If it has a value related somehow to a database field you can do something like that in the model definition:

hours_to_deadline.admin_order_field = 'database_field'

You can read more about it at https://docs.djangoproject.com/en/1.10/ref/contrib/admin/

score -2 · Answer 2 · answered Jan 26 '17 at 12:01

Answer is: ordering = ('-id',)

class JobAdmin(SuperModelAdmin):

    list_display = ['id', 'identificator', 'created', 'invoice__estimated_delivery','hours_to_deadline','customer__username', 'language_from__name', 'language_to__name',
                    'delivery__status', 'confirmed', 'approved', 'invoice__final_price']
    ordering = ('-id',)


    def hours_to_deadline(self,obj):
        try:
            return (obj.invoice.estimated_delivery - now())
        except:
            return None

I want to order using time_to_deadline but only, when admin clicks on the ordering. — Milano, Jan 26 '17 at 12:03

Django - sort records by custom column

2 Answers2