Configuration Guide

10.3 HotFix 3
- 10.5 HotFix 2
- 10.5
- 10.4 HotFix 3
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 2
- 10.3 HotFix 1
- 10.3

Back Next

Defining Functions

You can add aggregate functions to the columns in your queries. For example, you can use COUNT, MIN, or MAX on the data retrieved from the column. You can also edit and remove functions from the query.

The following code sample shows a function in an SQL statement:

select col1, COUNT(col2) as c1 from table_name

In the properties pane, click the

Select

tab.

Click the

Add Function

icon.

The

Add Function

dialog box opens.

Select the column.

Select the function.

Click

The function appears in the table.

Optionally, you can edit, reorder, or remove functions.

Option	Description
Edit	Select the function, and click the Edit icon.
Reorder	Select the function, and click the Move Up or Move Down icon.
Remove	Select the function, and click the Delete icon.