Warning | ||
---|---|---|
| ||
|
Note |
---|
In order to use dependent fields you must have JJUPIN plugin Power Scripts for Jira app installed and enabled. |
In order to To use the screen values for a field in the data source, you have to add it as dependent field ( from the field configuration → > Dependencies).
ExampleExample: Let's suppose say we have two custom fields: one KCF PCF-PRO - Single Autocomplete (let's name it "Continent") and one KCF ) and PCF-PRO - Multiple Autocomplete (let's name it "Countries"), the second one is populated depending on the value of the first one.
An easy example would beis following: we have a table ( "countries") table with two columns: country and continent. Our first field will select the continents and the second one will contain the countries from that continent.
You can see the corresponding data sources below:
The The following data source for represents the first custom field:
Code Block |
---|
select distinct continent from countries; |
The The following data source for represents the second custom field:
Code Block |
---|
select country from countries where continent = {customfield_10800} |
In The following result will be in the issue view screen, the result will look like this:
...
Note |
---|
For the moment, dependent fields can only be used by the two custom fields with autocomplete, Starting with Power Custom Fields PRO 4.0.0, you can now use the dependent fields on SQL data sources as well. In order to get the value set on the screen for one custom field, you will have to refer reference it like this: "argv[customfield_id]". |