How to sort on SUM Alias

[Kattouf]

Hello,

I have a query that includes a SUM aggregate alias. Normally i would use a custom query but did it with the normal query manager.

How do i go about sorting on that alias now?

I tried putting values in the SORT and DIR in both the server action and in Server connect. But i don’t think i am doing it right.

Do i just bind SORT to the field and then type DESC in the Order?

Basically i get “column not found: 1054 Unknown column”. I can sort using other columns.

thanks

/J

[Kattouf]

Never mind i see it’s a feature request.

Sort database queries on aggregated fields

Aggregated fields derived in a database query can’t be used to sort the output as they are not available in the field list for selection in the ‘Sorting’ tab. An example use case is two tables, customers and invoices, joining them to output ‘total sales’, ‘total debt’ or ‘total overdue debt’ per customer for display to the user. Sorting on ‘total overduedebt’, for example, allows the user to prioritise follow up actions. An alternative to do this through the front end using Query Manager does …