How to configure

Go to the Administration page, choose Custom Fields link and add an KCF - Single Autocomplete.

Image Removed

...

Contents

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

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

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

Adding PCF - Single Autocomplete custom field

1. Log into your Jira as Admin.
2. Go to Administration > Issues > Custom Fields page.
3. Click Add custom field and select PCF - Single Autocomplete.

After you add this field, you need to configure it as described on the Configuring Power Custom Fields PRO™ page.

Using PCF - Single Autocomplete custom field

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

Image Modified

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

Image Modified

Example for data source

...

Examples

Using Single Autocomplete custom field with SIL Data Source

Getting Issues

This example gets 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

This example is used to generate the pictures above. It gets all the created issues with the summary matching the search.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 PRO
• Data Source Configuration