Quick Steps for Creating a Parameterized Query
Here are some quick steps for using a table in a parameterized query. For details and diagrams, see
Add Input Parameters.
To create a parameterized query
1. Select File > New > Parameterized Query from the menu bar, and give it a name.
2. Add the appropriate table to the Model panel on the right.
3. Click the Grid tab.
4. On the Grid panel, specify a column to project, or leave the cell entry as * (to select all columns).
5. Right-click a blank Column cell, and select Parameter.
6. In the Add Parameter dialog:
a. Type a unique name for the parameter in the Parameter Name field (for example, selectedValue).
b. Select a data type from the drop-down list, and click OK.
The entry is displayed in the Grid in the following format:
{param <parameter name> <parameter data type>}
The corresponding Alias cell is automatically assigned a unique value (for example, Expr1).
7. Click the icon to execute the parameterized query.
The Input Values for <resource> window opens and prompts you to provide a value for the parameter you added in a previous step.
8. Type in the value for the parameter and click OK to execute the query.