Define Dependent Parameters in Job Definitions

This example demonstrates how to define dependent parameters.

This table summarizes key decisions for this scenario.

Decisions to Consider	In this Example
Which parameters do I want to make dependent?	Region, Country and City. Region list of values includes the names of the regions like North America, EMEA, JAPAC and so on. The Country list of values includes the names of countries like USA, Canada, France, England, India, Japan and so on. Similarly City list of values includes the names of different cities like New York, Washington, London, Paris, Mumbai, Tokyo and so on. The Country parameter list of values includes only the countries like USA, Canada and so on, if user selects North America. The City parameter list of values includes the names of the cities in the country that the user has selected.
What are view criteria?	The view criteria determine the values that appear in the dependent parameter list of values for the users to see. The view criteria are used to filter the list and pass the required bind variables based on the user's selection. To filter countries based on the selected region, you must select `getCountriesByRegion` and pass Region as a bind variable.

Decisions to Consider

In this Example

Which parameters do I want to make dependent?

Region, Country and City.

Region list of values includes the names of the regions like North America, EMEA, JAPAC and so on. The Country list of values includes the names of countries like USA, Canada, France, England, India, Japan and so on. Similarly City list of values includes the names of different cities like New York, Washington, London, Paris, Mumbai, Tokyo and so on. The Country parameter list of values includes only the countries like USA, Canada and so on, if user selects North America. The City parameter list of values includes the names of the cities in the country that the user has selected.

What are view criteria?

The view criteria determine the values that appear in the dependent parameter list of values for the users to see. The view criteria are used to filter the list and pass the required bind variables based on the user's selection.

To filter countries based on the selected region, you must select getCountriesByRegion and pass Region as a bind variable.

Prerequisites

Create the parameters Region, Country and City. The values available to the users in the Country parameter list of values depends on the value selected for the Region parameter. City parameter list of values depends on the value that the user selects for the Country parameter.

Defining Dependent Parameters

To define parameters with dependent lists of values:

On the Manage Job Definitions tab, open the Parameters sub tab.
Select the Region parameter.
Click the Manage Dependencies button located next to the Delete button.
From Available View Criteria, select getCountriesByRegion and move it to Selected View Criteria using the move icons.
The selected view criteria appears in the Bind Variables section.
In the Bind Variables section, for the getCountriesByRegion view criteria, select Country from the mapped parameters list of values.
The Country parameter list of values is now dependent on the value selected for the Region parameter.
Click OK.
Repeat the steps with Country parameter. Select getCitiesByCountries from the available view criteria and pass City as a bind variable.