Quicker way to Group By fields of an entity
377
Views
3
Comments
New
Aggregates & Queries

Every so often I have an aggregate with a bunch of Entities and these have a bunch of fields. If I start selecting the fields to Group By, and run into a field to expand (most likely an Id), I loose the previously selected fields.

So my idea has to do with perhaps a quicker way to Group By fields and it goes something like this:

1. In the aggregate's sources, we'd right-click on the entity, and have an option to 'Group By fields'

2. After selecting the option above, we could see a dialog similar to the one we get when we choose to add, to the Local Storage, an Entity from Database - dialog that shows the entity fields and you choose which ones you want to group by:


Cheers!

Changed the category to
Aggregates & Queries
Merged this idea with 'Select field to group in the aggregate in a list' (created on 28 Nov 2020 19:42:37 by Eduardo Rodrigues)

Having the possibility to select the fields to group in the aggregates through a drop-down list, without having to do the side scroll to search for the fields you need to group. There are queries that have a very large number of canpos and it is difficult to find the fields you want to group, because many fields are still hidden.



This comment was:
- originally posted on idea 'Select field to group in the aggregate in a list' (created on 28 Nov 2020 by Eduardo Rodrigues)
- merged to idea 'Quicker way to Group By fields of an entity' on 29 Dec 2020 11:39:45 by Ângela Dinis