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

Question

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.

Answer 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;
}