How to modify an .epr file for an ODA data source query

1	In Navigator, double-click the appropriate .epr file.

2	In General:

To modify the query in Query text, choose Query Builder.

In Description, type a description for the query.

Figure 2-49 shows General with a description of the query and the Query Builder button.

Figure 2-49

Choosing Query Builder to modify the query

3	Choose Parameters.

The query’s parameters appear.

4	In Parameters:

To rename a parameter, type the new name in Parameter.

Information Object Designer assigns a default name to a parameter based on its position in the query, for example param_1.C

If necessary, choose the correct data type from the Data type drop-down list.

In Default value, type the parameter’s default value.

Do not create an expression. You cannot type a default value for an output parameter.

To specify the parameter’s prompt properties, choose Prompt editor. Figure 2-50 shows the Parameters pane for a map using an ODA data source.

Figure 2-50

Specifying prompt properties for an ODA data source query’s parameters

To define other parameter properties, select the parameter and define the properties in Properties.

5	Choose Data Set Properties.

The data set properties appear, if the data set has any. Figure 2-51 shows the Data Set Properties pane.

Figure 2-51

Data Set Properties pane

6	In Value, type values for the data set properties.

 

Copyright Actuate Corporation 2012