Loading TOC...

cts.sumAggregate

cts.sumAggregate(
   $range-index as cts.reference,
   [$options as String[]],
   [$query as cts.query?],
   [$forest-ids as String[]]
) as xs.anyAtomicType?

Summary

Returns the sum of the values given a value lexicon. This function works like cts:sum except it performs the calculation in parallel in all data nodes then aggregates the values. It generally performs better than cts:sum, especially on large clusters.

Parameters
$range-index Reference to a range index.
$options Same as the "options" parameter in cts:aggregate.
$query Same as the "query" parameter in cts:aggregate.
$forest-ids Same as the "forest-ids" parameter in cts:aggregate.

Example

//   This query assumes an element range index is configured
//   in the database for the 'Amount' element.

cts.sumAggregate(cts.elementReference(xs.QName("Amount")));

=> 733.7600000000000128

Comments

    Powered by MarkLogic Server 7.0-4.1 and rundmc | Terms of Use | Privacy Policy