Report Definition rules
Using the Function Builder

Purpose

The Function Builder appears in a pop-up window and lets you select an existing SQL function template to use as the basis for the SQL function you wish to use. When you have selected the template, the form displays further fields where you select the data fields the function is to use.

Process Commander provides a large number of standard SQL function templates: see Atlas — Standard SQL function rules for a descriptive list. If none of the standard rules fit the needs of your report, you can create your own Function Alias rule. See About Function Alias rules.

Operation

• To display the Function Builder, on the Design tab of a Report Definition rule click the Function Builder icon ( ) to the right of the column in which you want to display the results of a SQL function.
• When the Function Builder appears, it displays a single field. Type the first few characters of the function you want, or use the down-arrow to display a list of available functions. Standard functions appear first, followed by any custom functions developers in your team have added.
• When you select a function, a template appears with further fields that allow you to identify data columns and the way you want the function to process them.
• Click Submit to apply the function to the report column. Click Cancel to abandon the operation and close the Function Builder.

About Report Definition rules