Re: order_by result of sum of fields computed from an annotate

Well, indeed the matter is not simple =) I looked at the raw SQL for your queries and the results are the following (just print queryset.query to show SQL). The SQL query for Author.objects.extra(select={'average_delay': "Avg('all_books__published_date')-Avg('all_books__added_date')"}) is SELE

Re: order_by result of sum of fields computed from an annotate

I'm sorry, you are right, I should have provided them. Let me formulate the question again, but with a complete example. # models.py class Book(models.Model): added_date = models.DateField()# date it was added to my shelf published_date = models.DateField() # date it was publishe

Re: order_by result of sum of fields computed from an annotate

May you please post the code of Book and Author models? Thanks Leonardo Giordani Author of The Digital Cat My profile on About.me - My GitHub page- My Coderwall profile

order_by result of sum of fields computed from an annotate

Hi there. Consider the situation where you want to order_by a sum of two fields obtained from an annotation. This problem states it correctly, however, the solution is not working for me. For conc