Loading TOC...

op:named-group

op:named-group(
   $name as xs:string,
   [$columns as columnIdentifier*]
) as map:map

Summary

This function specifies the grouping keys for a group as a named list of zero or more columns. The result is used for building the first parameter for the op:group-to-arrays function.

Parameters
$name The name for the list of grouping keys.
$columns The columns (if any) to use as grouping keys. The columns can be named with a string or a column parameter function such as op:col or constructed from an expression with op:as.

See Also

Example

xquery version "1.0-ml";

import module namespace op="http://marklogic.com/optic"
     at "/MarkLogic/optic.xqy";

op:from-view("main", "expenses")
    => op:group-to-arrays(
        (op:named-group('total'), op:named-group('byCategoryLocation', ("Category", "Location"))),
        op:sum("TotalAmount", "Amount"))
    => op:order-by(("Category", "Location"))
    => op:result()
  

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.