Group Example

Group Example

    ...

    //Group by fields
    List columns = new ArrayList();
    columns.add("field1");
    columns.add("field2");

    //Aggregate functions 
    // (fieldname,label,function,java type,sqltype)

    List group = new ArrayList();
    group.add(new GroupUnit("NAME", "count", GroupFunction.GROUP_COUNT, 0, 0));
    group.add(new GroupUnit("AMOUNT", "sum", GroupFunction.GROUP_SUM, 0, 0));
    group.add(new GroupUnit("AMOUNT", "avg", GroupFunction.GROUP_AVG, 0, 0));
    group.add(new GroupUnit("QTY", "count_over_all", 
            GroupFunction.GROUP_COUNT_OVER_ALL, 0, 0));
    group.add(new GroupUnit("AMOUNT", "sum_over_all",
            GroupFunction.GROUP_SUM_OVER_ALL, 0, 0));
    group.add(new GroupUnit("AMOUNT", "max", GroupFunction.GROUP_MAX, 0, 0));
    group.add(new GroupUnit("AMOUNT", "min", GroupFunction.GROUP_MIN, 0, 0));
    group.add(new GroupUnit("AMOUNT", "distcount",
            GroupFunction.GROUP_DISTINCT_COUNT, 0, 0)); 

    // Group data into a new rowset
    ResultSet rs1 = rs.group(columns, group);

    ...