MarkLogic 10 Product Documentationcts:sum
cts:sum( $arg as xs:anyAtomicType*, [$zero as xs:anyAtomicType?] ) as xs:anyAtomicType?
Summary
[DEPRECATED: use cts:sum-aggregate]
fn:sum except each item in the
sequence is multiplied by cts:frequency before summing.
| Parameters | |
|---|---|
| arg | The sequence of values to be summed. The values should be the result of a lexicon lookup. |
| zero | The value to return as zero if the input sequence is the empty sequence. |
Usage Notes
The cts:frequency of the result is the sum of the
frequencies of the sequence.
This function is designed to take a sequence of values returned
by a lexicon function (for example, cts:element-values); if you
input non-lexicon values, the result will always be 0.
Example
xquery version "1.0-ml";
(:
This query assumes an int range index
is configured in the database. It
generates some sample data and then
performs the aggregation in a separate
transaction.
:)
for $x in 1 to 10
return
xdmp:document-insert(fn:concat($x, ".xml"),
<my-element>{
for $y in 1 to $x
return <int>{$x}</int>
}</my-element>);
cts:sum(cts:element-values(xs:QName("int"), (),
("type=int", "item-frequency"))),
cts:sum(cts:element-values(xs:QName("int"), (),
("type=int", "fragment-frequency")))
=>
385
55