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

...

Examples

Using Single Autocomplete custom field with SIL Data Source

 Get Issues 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;

This example is used to generate the pictures above. It gets all the created issues with the summary matching the search.

Example for SQL Data Source

...

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 pname from issuetype;

This example returns the name of issue type.

Related Content

...

 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