op:array-aggregate

op:array-aggregate(
   $outCol as item(),
   $inCol as item(),
   [$options as map:map?]
) as map:map

Summary

This function constructs an array whose items are the result of evaluating the column for each row in the group or row set. The result is used for building the parameters used by the op:group-by function.

Parameters
$outCol	The name to be used for the aggregated column.
$inCol	The columns to be aggregated.
$options	The options can take a values key with a distinct value to average the distinct values of the column.

Example


xquery version "1.0-ml";

import module namespace op="http://marklogic.com/optic"
     at "/MarkLogic/optic.xqy";

let $expenses := op:from-view("main", "expenses")
 
return $expenses
    => op:group-by("Category", op:array-aggregate("Expense Array", "Amount"))           
    => op:order-by("Category")
    => op:result()