Loading TOC...


   [$columns as columnIdentifier[]]
) as groupdef


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 prototype.groupByUnion function.

$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


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

op.fromView('main', 'expenses')
       [op.group(), op.group(['Category', 'Location'])],
       op.sum("TotalAmount", "Amount")
   .orderBy(['Category', 'Location'])


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