PCF - Single Select

Table of Contents

1 Using the PCF - Single Select custom field
2 Examples
- 2.1 Using Single Select custom field with SIL Data Source
  - 2.1.1 Getting Project Versions
- 2.2 Using Single Select custom field with SQL Data Source
  - 2.2.1 SQL Initial Script

The Single Select custom field enables you to select an option in the select list field that is based on a SIL script.

This custom field can be used for the following options:

String (default)
Component Picker
Group Picker
Issue Picker
Project Picker
User Picker
Version Picker

Using the PCF - Single Select custom field

If edit this field for an issue, you will see an image similar to the following example (when the Option type is Component Picker):

Save the changes and the selected value will appear:

Examples

Using Single Select custom field with SIL Data Source

Getting Project Versions

The example gets project versions like in the image above.

string projectKey = "TEST";
string[] versionNames = admGetProjectVersions(projectKey);
number[] versionId;
for(string versionName in versionNames){
    JVersion version = admGetProjectVersion(projectKey, versionName); 
    versionId += version.id;
}
return versionId;

Using Single Select custom field with SQL Data Source

To use SQL Data Source, set the JNDI first. You can see details on the SQL Data Source page.

SQL Initial Script

The following example returns the versions names:

select vname, id from projectversion;

See More