How to create a GROUP BY clause manually

1	In Information Object Query Builder, choose Group By.

2	In Group By, deselect Use Automatic Grouping.

3	In Available, expand the Computed and Output nodes to view the available columns.

By default, Information Object Query Builder displays only output columns and non-aggregate computed fields. To group on a column that is not an output column, choose Show all.

4	In Available, select the appropriate column. Then, choose Select. The column name appears in Selected, as shown in Figure 2-35.

5	Repeat the previous step for each GROUP BY column.

6	To change the order of the GROUP BY columns, select a column in Selected, and use the up or down arrow.

Figure 2-35

Selecting a GROUP BY column

Copyright Actuate Corporation 2012