MarkLogic 10 Product Documentationop functions (Aggregate Functions for Building groupBy Parameters)
The following functions are aggregate functions for building parameters used by the prototype.groupBy method.
11 functions
| Function name | Description |
|---|---|
| op.arrayAggregate | This function constructs an array whose items are the result of evaluating the column for each row in the group or row set. |
| op.avg | This function averages the non-null values of the column for the rows in the group or row set. |
| op.count | This function counts the rows where the specified input column has a value. |
| op.groupConcat | This function concatenates the non-null values of the column for the rows in the group or row set. |
| op.hasGroupKey | This aggregate function adds a flag to a grouped row specifying whether a column acted as a grouping key for the row. |
| op.max | This function gets the largest non-null value of the column for the rows in the group or row set. |
| op.min | This function gets the smallest non-null value of the column for the rows in the group or row set. |
| op.sample | This function randomly selects one non-null value of the column from the rows in the group or row set. |
| op.sequenceAggregate | This call constructs a sequence whose items are the values of a column for each row in the group or row set. |
| op.sum | This function adds the non-null values of the column for the rows in the group or row set. |
| op.uda | This function processes the values of column for each row in the group or row set with the specified user-defined aggregate as implemented by an aggregate user-defined function (UDF) plugin. |