MarkLogic Server 11.0 Product Documentation

op.count

op.count(
   aggColName as String,
   [columndef as String],
   [options as Object]
) as aggregatedef

Summary

This function counts the rows where the specified input column has a value. If the input column is omitted, all rows in the group or row set are counted. The result is used for building the parameters used by the prototype.groupBy function.

Example

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

op.fromView('main', 'expenses')
   .groupBy('Category', op.count("Number of Expenses", "Amount", {values: 'distinct'}))
   .orderBy('Category')
   .result();