Loading TOC...
JavaScript op.group

MarkLogic 12 Product Documentation
op:group

op:group(
   [$columns as item()*]
) as map:map

Summary

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

Parameters
$columns The columns (if any) to use as grouping keys. The columns can be named with a string or a column function such as op:col, op:view-col, or op:schema-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-by-union(
        (op:group(), op:group(("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.