Acquiring a Query Parameter from a Query Field
Instead of acquiring a query parameter value from the user, you can provide the value by aggregating a field of another query. To do this, follow the steps below:
1. Open the desired query for editing. (Double-click the query in the Asset panel.)

2. Click the 'Parameters' button in the toolbar. This opens the 'Query Variable Definition' dialog box. The 'Variable List' panel at the top displays any query parameters that have been specified in the query condition.
3. Select the desired variable in the 'Variable List' panel.
4. Click the 'Query Variable' button (if not already selected).

5. In the 'Query' panel, select a query from the top menu. This displays a list of query fields in the panel below.

6. Select the desired query field, and click 'Select Record'. This places a marker (diamond) next to the selected field.
7. From the 'Aggregation' menu, choose a summarization method. If you select 'None', the first value from the query result set will be used.
8. (Optional) To filter the selected query, click on the query name, and then click the 'Edit' button below the 'Condition' panel. This opens the 'Conditions' dialog box, where you can specify a filtering condition.
| << Acquiring a Query Parameter from User Input | © 1996-2013 InetSoft Technology Corporation (v11.4) | 3.6 Auto Back-Up and Recovery >> |