Interstage Shunsaku Data Manager Application Development Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

3.7 Extracting Aggregated Results

XML documents found using a search expression can be grouped and aggregated according to a given key. To perform aggregation, include the aggregation function specification in the return expression. A group key must also be specified in the sort expression. To produce the results of the aggregation function specification, XML documents with the same group key are treated as a single group. The data indicated by the text expression or attribute expression specified as the argument of the aggregation function specification is treated as a numeric value for each group, and then totals, averages, and other values are determined.

Refer to B.4.3 Format Used when Aggregating for more information on return expressions.

The following figure provides an overview of the aggregation process.

[Figure 3-3 Overview of the Aggregation Process]

This is the method used to decide how search results will be grouped, and what will be aggregated.

• Grouping Search Results
• Aggregating Search Results

---

3.7.1 Grouping Search Results

3.7.2 Aggregating Search Results