0
 Followers
3
 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 2018
Comments (1)

Changed the category to Aggregates & Queries


views
690
Followers
0