======== TEMPLATE BUG FORM ========
Wappler Version : 3.0.1
Operating System : Windows 10
Sorting on an aggregate column should sort correctly
Sorting by aggregate columns produces the wrong result - the order is incorrect.
How to reproduce
Create a query using Query Builder, including columns using aggregate functions - eg COUNT() or SUM().
Include these columns when creating a table with the table generator, including sort options. Problem: while other, non-aggregate columns sort as expected, aggregate columns appear to sort randomly. It seems an additional column is added to the ORDER BY statement (eg the column used for the COUNT() expression).
This issue was originally raised in this thread which has more examples and details.