bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

Building Queries and Data Views

Using Query Parameters

You can use the Query Parameters panel to add variable values to a query each time you run it. The list of variables depends on the number of variables you defined as Query Parameters on the Design tab and which ones appear as one or more function parameters. (For details on defining query parameters, see Query Parameters: Defining, which includes a list of supported data types for query parameters in Table 2-2.)

Figure 5-2 Query Parameters Settings on Test Tab

Double-click into a cell in the Values column to type a value.

Figure 5-3 Entering Values for Query Parameters

For some examples of using query parameters see the following example queries in the Query Cookbook.

- Example 1: Simple Joins

- Example 2: Aggregates

- Example 3: Date and Time Duration