Example 8 - Dependent fields and SQL data sources

For this example, we will show SQL data sources and dependent fields. We have two custom fields: PCF - Single Autocomplete named Continent and PCF - Multiple Autocomplete named Countries. Countries is populated based on the value of Continent.

We have a "countries" table with two columns: country and continent. Our first field will select the continents and the second one will contain the countries on that continent.

To use the screen values for a field in the data source, add it as a dependent field from the field configuration > Dependencies.

The following data source represents the first custom field:  

select distinct continent from countries;

The following data source represents the second custom field:  

select country from countries where continent = {customfield_10800}

The following result will be in the issue view screen: