6
 Followers
47
 Likes

[Service Studio] Improve Aggregates to allow entity/attribute filtering

Aggregates & Queries
On our radar

Sometimes when the Aggregates have many entities and attributes it's hard to find a column/attribute.

In my case, i had issues to find the column i wanted to group by and it took me a lot of time to find it.

I think this idea can help improve the development speed.

Created on 26 Oct 2018
Comments (24)

I have also often felt this pain.

Changed the category to Aggregates & Queries


Yup, really annoying when having 20 Entities with 20 columns each :)

I really need this!!

Merged this idea with 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 13:01:49 by Romero)

Sometimes I just want to check a specific value on my query and If I am testing my simple query and it happens to have at least 5-6 entities with 9 columns each it I have at least 45 to 54 attributes. Although we have the table name to help I don't think that it is enough, even more when we have some attributes collapsed

In order to improve this, we could do it in two simple ways :

1st - Add one dropdown to filter per Entity (this filter is visual only, not one query filter )


2nd - Apply colors to be easier to find the entity/attribute.

 Everytime you add one entity to the aggregate you can choose a color for it ( changing this color would not automatically apply according to the new change's on the aggregate. You would have to press the "refresh now" as we usually do to check changes) or if you don't,  apply's the default one.





This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

Changed the category to Aggregates & Queries




This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

Hi Romero,


I like your idea, as I feel that pain quite often.

A 3rd and simpler option could be just having a search box to type the entity attribute we're looking for. This option could also allow the use of wildcards to search for those attributes, such as the asterisk.



Cheers!



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

Hi Ricardo,

I like your suggestion as well ! This idea is very generic since it can be done in many ways. I just feel the need to have some visual filters for the aggregate.

Maybe the title should be changed to "Aggregates improvement - Visual Filters" (if any moderator see's this please change in order to be more specific).





This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

I agree, this idea is very useful. Some times i need something to don´t lose 



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

I agree that finding an attribute in such a scenario is a big pain. There's definitely work to be done there. I don't have a suggestion, but I bet guys at R&D are able to come up with a great solution if we give the feedback of how real the pain is :)




This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

Pedro I agree that R&D can provide us with this new feature in many ways, so feedback on this one is highly appreciated from all of us  !



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

That is a very goog idea. 



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

This feature is needed for yesterday guys.. It is impossible to work with more than 5 entities in the same aggregate, it's just a mess and time consuming searching for what i really want to check.



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

I really need this!!



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

+1

@Outsystems, could you merge this idea with this one:

https://www.outsystems.com/ideas/5720/service-studio-improve-aggregates-to-allow-entity-attribute-filtering

They seems duplicated.



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

Still can't believe that the platform has grown and improved so much in so many ways and we still have to search for a specific field in the middle of other 60 attributes and on top of that pay attention cause it might be collapsed...



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

UP this is needed OS !!!



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

Very good idea, specially the colors for entities.

There is a workaround for finding an attribute with ease, use the Hide Others context menu from any attribute then from the data tab drag the attributes you want to see in the preview.



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis

UP this is needed OS !!!



This comment was:
- originally posted on idea 'Aggregates improvement - Visual Filters' (created on 28 Nov 2018 by Romero)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 18 Nov 2020 13:52:11 by Ângela Dinis
Changed the status to
On our radar


Hi Luís,

Thank you so much for your idea. I am marking it as "On our radar" because this is something I believe our community would benefit from while dealing with Aggregates. We'll keep in touch. Thanks!

Merged this idea with 'Improve show/hide columns inside of an aggregate' (created on 26 Feb 2021 11:40:59 by Goncalo Almeida)

Sometimes when we have several entities inside of an aggregate it's hard to set the columns that we want to see.


My suggestion is in the menu of the dropdown of a column, create a new option, opening a submenu with the entities and another one with the attributes of each entity with a multi-select in order we can check-uncheck the columns we want to see/hide.


here is the screenshot of my idea.

Regards

Gonçalo Almeida




This comment was:
- originally posted on idea 'Improve show/hide columns inside of an aggregate' (created on 26 Feb 2021 by Goncalo Almeida)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 27 Feb 2021 13:26:18 by Daniël Kuhlmann

I totally back your idea, Gonçalo. It's really difficult to manage a lot of columns in an aggregate without features that help us find and go to directly what we want.

Additionally, I would like to have an option to bulk remove custom columns. Today it's only possible to remove one column at a time.


Cheers!



This comment was:
- originally posted on idea 'Improve show/hide columns inside of an aggregate' (created on 26 Feb 2021 by Goncalo Almeida)
- merged to idea '[Service Studio] Improve Aggregates to allow entity/attribute filtering' on 27 Feb 2021 13:26:18 by Daniël Kuhlmann
views
1336
Followers
6