Loading TOC...
XQuery op:sequence-aggregate

MarkLogic 12 Product Documentation
op.sequenceAggregate

op.sequenceAggregate(
   aggColName as String,
   columndef as ColumnIdentifier,
   [options as String]
) as aggregatedef

Summary

This call constructs a sequence whose items are the values of a column for each row in the group or row set. The result is used for building the parameters used by the prototype.groupBy function.

Parameters
aggColName The name to be used for the aggregated column.
columndef The column to be aggregated. The column can be named with a string or a column function such as op.col, op.viewCol, or op.schemaCol, or constructed from an expression with the op.as function.
options The options can take a values key with a 'distinct' value to aggregate the distinct values of the column.

Example

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

op.fromView('main', 'expenses')
   .groupBy('Category', op.sequenceAggregate("Sequence Array", "Amount"))
   .orderBy('Category')
   .result();

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