Aggregates: reorder filters

By Carlos Henriques on 13 Jun 2016
We should be able to reorder filter elements as we can reorder sort and joins.
Carlos Xavier14 Jun 2016
Hi Carlos,

What is the purpose of that feature? Is it just to improve readability?
Justin James15 Jun 2016
Yeah, there's no technical/practical reason for this, unless you feel that it might help the SQL be slightly more optimized?

Carlos Henriques17 Jun 2016
Yes, essentially to improve readability of the filters section.

Many times you expect some filters to be always at the same position, for instance, the common "LIKE ... SearchKeyword ..." to be always at the top of the list.
Kilian Hekhuis21 Jun 2016
Yes, definitely this. @Justin: we typically like to group the restrictions per table, e.g.

MyTable1.value > someValue
MyTable1.userName = userName > currDate <= currDate

and then oh, we forgot a filter on MyTable1. That'll end up below the MyTable2 filters, which is difficult to maintain, especially if you have joined 10 tables each with their own filters.
Tiago Bernardo6 Jul 2016
Just right now I wanted this feature to be available. Searched if someone already had think about and voilà, here it was. Like it.