0
 Followers
2
 Likes

Add real conditional filters in aggregates

Aggregates & Queries
On our radar

Even using the technique as described in https://www.outsystems.com/forums/discussion/18398/how-to-use-if-condition-in-the-aggregate-filter/ an aggregate fires a complex SQL statement to the database if all filters are set to generic "give me all". This results in a poor performance of what should be a simple instant reply query. See attachment of a query that should do a simple 'select count(1) from "FAOFH88" ENFAOFH88'

It would be a huge performance booster if the filters could be made conditional.

 Count from aggregate with conditional filters set to ALL.txt
Created on 23 Feb
Comments (1)

Changed the category to Aggregates & Queries


views
194
Followers
0