Loading TOC...

op.arrayAggregate

op.arrayAggregate(
   $aggColName as String,
   $columndef as String,
   [$options as String]
) as aggregatedef

Summary

This function constructs an array whose items are the result of evaluating the 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 columns to be aggregated.
$options The options can take a values key with a distinct value to average the distinct values of the column.

Example

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

op.fromView('main', 'expenses')
   .groupBy('Category', op.arrayAggregate("Expense 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.