MarkLogic 10 Product DocumentationValuesSearch.aggregate
ValuesSearch.aggregate( name as stringOrUDF[] ) as ValuesSearch
Summary
Applies one or more aggregates to the values in the index. Exclusive with respect to the match(), groupInto(), orderBy(), slice(), map(), and reduce() clauses.
Usage Notes
You can only use theValuesSearch.where and
ValuesSearch.withOptions clauses with this method.
You cannot use other query modifiers such as
ValuesSearch.slice or ValuesSearch.orderBy.
See Also
- Computing Aggregates Over Range Indexes in the Search Developer's Guide
Example
// Compute aggregates using built-in aggregate functions
const jsearch = require('/MarkLogic/jsearch.sjs');
jsearch.values('price')
.aggregate(['min','max','avg'])
.result();
// Result: {"min":8, "max":30, "avg":16.125}
Example
// Compute aggregates using a UDF
const jsearch = require('/MarkLogic/jsearch.sjs');
jsearch.values('price')
.aggregate(jsearch.udf('native/sampleplugin', 'count'))
.result();