MarkLogic 10 Product Documentation

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.

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()