op.group

op.group(
   [columns as columnIdentifier[]]
) as groupdef

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

Parameters
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')
   .groupByUnion(
       [op.group(), op.group(['Category', 'Location'])],
       op.sum("TotalAmount", "Amount")
       )
   .orderBy(['Category', 'Location'])
   .result();

  
Powered by MarkLogic Server | Terms of Use | Privacy Policy