11
 Followers
47
 Likes

Aggregates: reorder Filters, etc.

Aggregates & Queries
Working on it
expected delivery in Q4 2018

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 (28)
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.

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
Merged this idea with 'Aggregates: reorder filters' (created on 2016-06-13 11:05:54 by Carlos Henriques)
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
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
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
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
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
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

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

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
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
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

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

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

Changed the category to Aggregates & Queries




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

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

Changed the category to Aggregates & Queries


I think this idea should be merged with this one.



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

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

@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

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

 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
Merged this idea with 'Ability to reorder filters in aggregates' (created on 10 Jul 2018 09:08:37 by César Miguel Cação)

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

Changed the category to Aggregates & Queries




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

Up please

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.


views
687
Followers
11