PCF-PRO - Single Autocomplete

Owned by Alexandra Topoloaga (Unlicensed)
Last updated: Aug 16, 2019 by Chelsea Bauer (Deactivated)
2 min read

Power Custom Fields PRO™ is becoming Power Custom Fields™


Power Custom Fields PRO™ is being upgraded to Power Custom Fields™. We are removing Power Custom Fields PRO™ from the market to focus resources on the combined app, Power Custom Fields™ which has all the features of PRO™ and more. Existing Power Custom Fields PRO™ users can get 65% off their new Power Custom Fields™ license by following the steps here.


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 the following types of options: 

  • 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 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

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

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