I suspect the problem is caused by a non-obvious detail that definitely needs an usability improvement. Similarly to filters, which are split in "standard" Filters and Group Filters, there's also the notion of Group Sorts and "standard" Sorts, although that's not reflected in the editor. And when an Aggregate has groups, "standard" Sorts are completely ignored...
To see if that's your scenario, try this:
If it doesn't, then your sort is actually a "standard" Sort and is being ignored.
To fix it, just delete the Sort and add a new Dynamic Sort with the same expression as before. Since the Aggregate is grouped, this will create a Grouped Sort.
Let me know if this helped.
Thanks Paulo! It worked. I had to delete the sort and add it again, but then it was in the executed SQL.
I have the same problem and found Paulo's solution works for me too.
However, where can I find the Executed SQL property of the Aggregate?
I am on version 9.1.603.0
Stanley Mok wrote:
When inside the aggregates editor (Double clicking on aggregate), you should see the following:
Let me know if you have any trouble,
Go t it.