Aggregate Basic functions in simple queries
1419
Views
6
Comments
Implemented
Aggregates & Queries
OutSystems 9
A "Group By" option it would be great, a SUM too
2020-02-04 07-58-32
Matthias Preuter
mvp_badge
MVP
It's cheaper to use Advanced queries (2 instead of 20 su!!), and you have more control over the SELECT sentence.
2016-04-21 20-09-55
J.
mvp_badge
MVP

adv. queries are more cumbersome. I like simple queries :)
2020-12-08 09-54-09
Evert van der Zalm
mvp_badge
MVP
Advanced are cheaper indeed, only also take more time to make.

Like this idea mostly for the group by function.
The result of simple queries is a record join with all the records of the entities required by the query.

With a group by the result would have only have a couple of fields and has no direct translation to entity records.

This is the kind of advanced operations advanced queries are for.
Same applies for aggregator functions.
2016-11-21 23-23-05
Gonçalo Borrêga
If we could have this in a way that the simple query results would be hierarchical it would be awesome... Ex: add some special group by operators on simple queries so that you get a hierarchical structure returned
 - Customer
     - Order
          - Order line
... maintaining the optimization of only getting the used fields, etc...
This would be a great improvement for advanced queries and an even greater if implemented on simple queries
I like the idea of having the "group by" function available in simple query.