op.min

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

Summary

This function gets the smallest non-null value of the column for the rows 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 smallest value.
columndef The group or row set.
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.min("Minimum Spent", "Amount"))
   .orderBy('Category')
   .result();
  
Powered by MarkLogic Server | Terms of Use | Privacy Policy