1
 Follower
24
 Likes

Aggregates: reorder Filters, etc.

Aggregates & Queries
On our radar
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
Created on 31 Mar 2015
Comments (11)
10 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.
20 Feb 2017
Merged this idea with 'Aggregates: reorder filters' (created on 2016-06-13 11:05:54 by Carlos Henriques)
13 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
14 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
15 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
17 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
21 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
6 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
17 Feb 2017

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
20 Feb 2017

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
10 Jul 2017

It would be nice if we could reorder aggregate conditions using drag-and-drop.




Merged from 'Reorder aggregate conditions' (idea created on 2017-07-10 19:53:51 by Gonçalo Martins), on 2017-07-11 09:19:58 by Kilian Hekhuis
views
95
Followers
1