Aggregates: reorder Filters, etc.

By Justin James on 31 Mar 2015
It would be nice to reorder the filters, etc. in the Aggregates view for organization purposes. Small but nice feature from simple queries.

J.Ja
Kilian Hekhuis10 Apr 2015
Yeah, that's one of the lesser concerns I had, so +1. In the beta, much has changed for the better, but this one is still missing.
João Costa17 Feb (7 days ago)

Add the same functionality that exists on the Sources tab to the Filters tab, allowing to reorder the filters rows.



Merged from 'Reorder Filters in Aggregates' (idea created on 2017-02-17 17:46:46 by João Costa), on 2017-02-20 11:50:12 by Carla Sofia Teixeira
Kilian Hekhuis20 Feb (4 days ago)

This is a duplicate of this one: http://www.outsystems.com/ideas/2490/aggregates-reorder-filters



Merged from 'Reorder Filters in Aggregates' (idea created on 2017-02-17 17:46:46 by João Costa), on 2017-02-20 11:50:12 by Carla Sofia Teixeira
Kilian Hekhuis20 Feb (4 days ago)

Oh, and this one: http://www.outsystems.com/ideas/1932/aggregates-reorder-filters-etc



Merged from 'Reorder Filters in Aggregates' (idea created on 2017-02-17 17:46:46 by João Costa), on 2017-02-20 11:50:12 by Carla Sofia Teixeira
Carlos Henriques13 Jun 2016
We should be able to reorder filter elements as we can reorder sort and joins.

Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira
Carlos Xavier14 Jun 2016
Hi Carlos,

What is the purpose of that feature? Is it just to improve readability?


Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira
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?

J.Ja

Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira
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.


Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira
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
MyTable2.date > currDate
MyTable2.date <= 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.


Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira
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.

Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira
Kilian Hekhuis20 Feb (4 days ago)

Haha, Justin, just saw your comment above, but you yourself posted this idea before: http://www.outsystems.com/ideas/1932/aggregates-reorder-filters-etc :))))



Merged from 'Aggregates: reorder filters' (idea created on 2016-06-13 11:05:54 by Carlos Henriques), on 2017-02-20 11:50:39 by Carla Sofia Teixeira