How to define a parameter

1	In Information Object Query Builder, choose Parameters.

2	In Parameters, select the top, empty line, and complete the following tasks:

In Parameter, type the name of the parameter. If a parameter name contains a special character or a space, enclose the name in double quotation marks.

In Data type, select a data type from the drop-down list.

In Default value, type the default value:

If Default value is a string, enclose the string in single quotation marks, as shown in the following example:

  'New York City'

If Default value is a timestamp, it must be of the following form:

  TIMESTAMP '2012-02-03 12:11:10'

If Default value is a number, use a period (.) as the decimal separator, as shown in the following example:

  123456.78

NULL is not a valid parameter value.

To change the order of the parameters, use the up or down arrow.

To use Prompt editor to specify the parameter’s prompt properties, choose Prompt editor, as shown in Figure 2-36.

Figure 2-36

Choosing Prompt editor to specify a parameter’s prompt properties

To define other parameter properties, such as display name, select the parameter in Parameters, and define the properties in Properties.

Copyright Actuate Corporation 2012