======== TEMPLATE BUG FORM ========
Wappler Version : 3.0.1
Operating System : Windows 10
Expected behavior
Sorting on an aggregate column should sort correctly
Actual behavior
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.