Contents

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 PCF - Single Autocomplete custom field

If you go to an issue and edit this field, you will see an image like the following example: 

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 Data Source Configuration page.

SQL Autocomplete Script

This 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 also

• Configuring Power Custom Fields™
• Data Source Configuration