How to sort a data set

To sort a data set based on an information object, use Information Object Query Builder to add an Order By clause to the SQL query that returns the data set.

1	In Information Object Query Builder, choose Sort.

2	Expand Output columns that appear listed in Available.

3	Using the right arrow, move a column name to Selected.

4	Optionally, to change the sort order:

1	Select Order. The Order type Asc, sorting rows in ascending order, appears by default.

2	To sort rows in descending order, select the order type. Then, choose Desc.

5	Optionally, to sort by multiple columns, repeat step 3 to select additional column names.

The example in Figure 2-33 shows selections that add an Order By clause using the column productName to a SQL query.

Figure 2-33

Adding an Order By clause to a SQL query

Copyright Actuate Corporation 2012