Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example: Let's say we have two custom fields: one PCF-PRO - Single Autocomplete and one PCF-PRO - Multiple Autocomplete, the second one is populated depending on the value of the first one.

An easy example would beis following: the first custom field has five options, representing the five continents, and the second one contains the countries from some table ("countries"), depending on the value selected on the first one. 

You can see the corresponding data sources below.

The following data source for represents the first custom field: 

Code Block
return {"AFRICA", "ASIA", "EUROPE", "AMERICA", "OCEANIA"};


 The The following data source for represents the second custom field: 

Code Block
string x = argv["customfield_10101"];
string[] res = sql("myDB", "select country from countries where continent like '" + x + "'");
return res;


In The following result will be in the issue view screen, the result will look like this


A similar example can be found here.

...