Back to Ideas
48
Like
Follow Idea
Aggregates: reorder Filters, etc.
3209Views
29Comments
Implemented
Aggregates & Queries
Development Environment 11.0.109.0

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

31 Mar 2015
Copy link to comment
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.
10 Apr 2015
Copy link to comment

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
17 Feb 2017
Copy link to comment
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
13 Jun 2016
Copy link to comment
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
14 Jun 2016
Copy link to comment
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
15 Jun 2016
Copy link to comment
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
17 Jun 2016
Copy link to comment
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
21 Jun 2016
Copy link to comment
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
06 Jul 2016
Copy link to comment

Haha, Justin, just saw your comment above, but you yourself posted this idea before: https://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
20 Feb 2017
Copy link to comment

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
10 Jul 2017
Copy link to comment
2016-03-14 11-51-58
Carla Teixeira
Merged this idea with 'Aggregates: reorder filters' (created on 2016-06-13 11:05:54 by Carlos Henriques)
20 Feb 2017
Copy link to comment
Merged this idea with '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (created on 05 Mar 2018 17:02:37 by Luis Soares)
10 Jul 2018
Copy link to comment

This can can lead to a better read of the code.



Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
05 Mar 2018
Copy link to comment

Yes!!! I knew I wasn't the only one that wanted this.


I like to keep the "Is_Active" filters at the top for ease of readability. Often, I find myself cutting and pasting the filters so I can change their ordering.


IMO it should work the same as the sorting filters.



Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
14 Mar 2018
Copy link to comment
Changed the category to
Aggregates & Queries
24 Apr 2018
Copy link to comment
Merged this idea with 'Aggregation filter order' (created on 24 May 2018 13:48:14 by Alberto Ferreira)

Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
29 May 2018
Copy link to comment

It would be usefull if, with a drag-drop behaviour, we could re-order the filters




Merged from 'Aggregation filter order' (idea created on 24 May 2018 13:48:14 by Alberto Ferreira), on 29 May 2018 14:55:27 by Kilian Hekhuis

Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
24 May 2018
Copy link to comment
Changed the category to
Aggregates & Queries
24 May 2018
Copy link to comment

Pretty sure there was already an idea for this, but too lazy to search for it :).



Merged from 'Aggregation filter order' (idea created on 24 May 2018 13:48:14 by Alberto Ferreira), on 29 May 2018 14:55:27 by Kilian Hekhuis

Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
29 May 2018
Copy link to comment

@Kilian 

You are right and it's "On our radar" from Outsystems team :)

https://www.outsystems.com/ideas/3565/%5bService+Studio%5d+Allow+change+filter+conditions+order+on+Aggregates+using+drag+%26+drop



Merged from 'Aggregation filter order' (idea created on 24 May 2018 13:48:14 by Alberto Ferreira), on 29 May 2018 14:55:27 by Kilian Hekhuis

Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
29 May 2018
Copy link to comment

Little addition, since it's being worked on:

Can the visible width of the filter statements be increased, so you have to open (or hover) the filters less often to see what's in them?



Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
11 Jun 2018
Copy link to comment
Merged this idea with 'Sort Aggregate Filters' (created on 05 Jul 2018 11:17:31 by David Castro)

Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
06 Jul 2018
Copy link to comment

 Possibility to sort Filters on Aggregates to order according user preference for a better organization.



Merged from 'Sort Aggregate Filters' (idea created on 05 Jul 2018 11:17:31 by David Castro), on 06 Jul 2018 14:57:52 by Justin James

Merged from '[Service Studio] Allow change filter conditions order on Aggregates using drag & drop' (idea created on 05 Mar 2018 17:02:37 by Luis Soares), on 10 Jul 2018 13:48:07 by Fernando Moitinho
05 Jul 2018
Copy link to comment
Merged this idea with 'Ability to reorder filters in aggregates' (created on 10 Jul 2018 09:08:37 by César Miguel Cação)
10 Jul 2018
Copy link to comment

As we are able to reorder joins in ours aggregates, can be interesting to have the same way to reorder the filters. It will not make difference in our aggregate results (like order of the joins do) but can helpful to order by business logic relevance or "group" by programmer thoughts



Merged from 'Ability to reorder filters in aggregates' (idea created on 10 Jul 2018 09:08:37 by César Miguel Cação), on 10 Jul 2018 13:53:20 by Fernando Moitinho
10 Jul 2018
Copy link to comment
Changed the category to
Aggregates & Queries
10 Jul 2018
Copy link to comment

Up please

02 Aug 2018
Copy link to comment
Changed the status to
Working on it
expected delivery in Q4 2018

Hi Justin,

We are working on this for the new OutSystems 11 version, stay tuned.


21 Sep 2018
Copy link to comment
Changed the status to
Implemented
on 26 Sep 2018

Hi Justin,

I'm glad to announce that this feature is available on the new OutSystems 11. 


Keep that feedback coming.


04 Oct 2018
Copy link to comment