Multiple Functions in List Aggregation - Mendix Forum

Multiple Functions in List Aggregation


List aggregation activity  needs the ability to select multiple functions at a time

Currently list aggregation supports only single function at a time like sum, count, average etc. If needs mutiple aggregation, one needs to fetch the list multiple times from the database to be able to use the benefit of database level aggregation function. For example, if one needs Sum, Count and Average from the same list, one catch ftehc the list once and use aggregate function three times, because in such cases, the fetch query is not optimized, in such cases, the only option is the fetch from database thrice and use the aggregate list activity thrice, a complete waster of resources and readeability. The other option is the use OQL, which further leads to readeabilty issues. The simple solution is to have multiple functions available in the list aggregation activity.

0 answers