Loading TOC...
XQuery op:named-group

op.namedGroup

op.namedGroup(
   name as String,
   [columns as columnIdentifier[]]
) as groupdef

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 prototype.groupToArrays 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

const op = require('/MarkLogic/optic');

op.fromView('main', 'expenses')
   .groupToArrays(
       [op.namedGroup('total'), op.namedGroup('byCategoryLocation', ['Category', 'Location'])],
       op.sum("TotalAmount", "Amount"))
   .result();

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