[Django]-Django models order_by non db field

by

4👍

✅

Look into the extra Django queryset operator:

q = Foo.objects.extra(select={'dif': 'foo_old_prize - foo_new_prize'})
q = q.extra(order_by = ['dif'])
👤Joseph Victor Zammit

3👍

You can use extra for this:

Foo.objects.extra(
    select={'diff':'foo_old_prize - foo_new_prize'},
    order_by=('diff',)
)
👤rafek

Leave a comment