Using the Add Parameter dialog (queryparm)

To prompt the user for a parameter value, check Prompt the user for a value. AQT will add a queryparm command to your query.

• Display Name is the name of the parameter on the parameter prompt
• Prompt user with has a number of options for how the user will be prompted. One of these is List of values, where the user is prompted with a dropdown list of values to choose from.
• Select from list can either be a fixed list of values, or a query to fetch the values from the database.
• IDParm. In this example, the Select from list query returns two columns. The first column is the value displayed in the dropdown list. When the user selects a value from the list, the parameter (depart) is set the selected value; the IDParm parameter (deptno) is set to the second column from the query.

  This is useful for displaying a list of "meaningful" values to the user, yet passing an internal value to the query.

When the query is run, the user will prompted as per the following screenshot.