User's Manual

120
Chapter 7
E Double-click or click the yellow arrow bu tton to add the field or function to the expression field.
E Use the operand buttons in the center of the dialog box to insert the operatio ns into the expression.
Selecting Functions
The function list displays all available CLEM fu nctions and operators. Scroll to select a function
from t he list, o r, for easier searching, use the drop-dow n list to display a subset of functions or
operators. Available functions are grouped into categor ies for easier searching.
Figure 7-7
Functions drop-down list
Most of these categorie s are described in the R eference section of the CLEM language descrip tion.
For more information, see the to pic Funct ions Reference in Chapter 8 o n p. 133.
The other categories are as follows.
 General Functions contains a selection of some of the most commonly-us ed functions.
 Recently Used contains a list of CLEM functions used within the curren t session.
 @ Functions contains a list of all the special functions, whi ch have their names preceded
by an “@” sign.
 Database Functions. If the stream includes a databa se connection (by means of a Database
source node), this selection lists the fun ctions available from within that database, including
user-defined functions (UDFs).
 Operators lists all the operators you can use when building expressio ns. Operators are also
availabl e from the buttons in the center of the dialog box.
 All Functions conta ins a complete list of available CLEM functio
ns.