MarkLogic 12 EA 1 Product Documentation

op:max

op:max(
   $outCol as item(),
   $inCol as item(),
   [$options as map:map?]
) as map:map

Summary

This function gets the largest 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 op:group-by function.

Example

xquery version "1.0-ml";

import module namespace op="http://marklogic.com/optic"
     at "/MarkLogic/optic.xqy";

let $expenses := op:from-view("main", "expenses")

return $expenses
	          => op:group-by("Category", op:max("Maximum Spent", "Amount"))
	          => op:order-by("Category")
	          => op:result()