Introduced in version: 1.3 (29 Jan 2020)
If a retrieve from the database and an aggregate are used they should be together, so Mendix can optimize the query to the database into 1 statement.
A similar rule Retrieve & aggregate combo should not be nullified by using the list checks usage of the retrieve list in other places that would prevent the optimization from taking place.
Noncompliant example:
Compliant example:
Multiple aggregates after one retrieve are allowed at the moment, assuming they can all be optimized into 1 statement. This needs further investigation.