Ordering by multiplication of several values in Django ORM?

Question

Possible Duplicate:
Django QuerySet ordering by expression

If I had a model with 3 integer fields, a,b,c, is it possible to do an order_by() on the value of abc within the ORM?

Answered here:
http://stackoverflow.com/questions/2926931/django-queryset-ordering-by-expression — amito, Aug 28 '11 at 11:26

score 1 · Answer 1 · answered Aug 28 '11 at 11:24

1

Absolutely. Use .extra(select=..., order_by=...), using the same name for both.

answered Aug 28 '11 at 11:24

score 0 · Accepted Answer · answered Aug 28 '11 at 11:29

0

Yes, although the syntax isn't pretty.

You can do this:

YourModel.objects.extra(
    select={'total': 'a * b * c'},
    order_by=['total'],
)

answered Aug 28 '11 at 11:29

Wolph

after you use select/extra you can not annotate on that data set, WHY? – A.J. Sep 02 '14 at 13:18

2 Answers2