Create filtered aggregates dragging a Entity attribute
552
Views
3
Comments
New
Aggregates & Queries

It would be useful to have the functionality to drag an entity attr and create an aggregate filtered by this attribute. To match the filtered attr, could show a popup to suggest the user to choose the input / variable to filter in query, or create a new one (input / variable).

Changed the category to
Aggregates & Queries
Merged this idea with 'Reactive - Shortcut to create queries by a local variable identifier' (created on 21 May 2021 15:16:20 by Fernando Santos)

In Traditional I was used to drag the local variable into the canvas and it created the "GetQueryById".

In Reactive we need to fetch the data from database, select the table (and then it adds unuseful related tables). I have to delete all related tables from the aggregate and the joins, and finally add the filter.

Here's a suggested solution:

Cheers!



This comment was:
- originally posted on idea 'Reactive - Shortcut to create queries by a local variable identifier' (created on 21 May 2021 by Fernando Santos)
- merged to idea 'Create filtered aggregates dragging a Entity attribute' on 23 May 2021 10:02:35 by Daniël Kuhlmann