PCF - Single Autocomplete

Table of Contents

1 Using the PCF - Single Autocomplete custom field
2 Examples
- 2.1 Using Single Autocomplete custom field with SIL Data Source
- 2.2 Using Single Autocomplete custom field with SQL Data Source
  - 2.2.1 SQL Autocomplete Script

The Single Autocomplete custom field enables you to select an option in the select list field based on a dynamic data source.

This custom field can be used for the following types of options:

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

Using the PCF - Single Autocomplete custom field

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

Save the changes and the selected value will appear on the issue screen:

Examples

Using Single Autocomplete custom field with SIL Data Source

The following script will get all created issues with the summary matching the search.

string [] issues = selectIssues("created < now()");
string [] res;
for (string iss in issues) {
    if (contains(iss.summary, argv["query"])) {
    	res = addElementIfNotExist(res, iss);
    }
}
return res;

Using Single Autocomplete 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 Autocomplete Script

The following example returns all issue keys:

select  p.project_key ||'-'||i.issuenum as "KEY"
from jiraissue i
inner join project_key p on p.project_id = i.project

See More