'want an example/illustration use of JS aggregates function in Oracle Apex

i saw the documentation here: https://docs.oracle.com/en/database/oracle/application-express/21.2/aexjs/model.html#.FieldMeta and want to have an example of using "aggregates" function in IG / IR where it is possible and how to. please guide.

oracle-apexaggregatesinteractive-grid


Solution 1:[1]

For each column you want to use aggregates in a JavaScript Initialization Code
add:

function(options) {
    options.defaultGridColumnOptions = {
        aggregates: ["SUM"] //or : "COUNT", "COUNT_DISTINCT", "AVG", "MIN", "MAX", "MEDIAN"
    };
    return options;
}

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 TonyS

Related Questions