Skip to end of banner
Go to start of banner

PCF - Single Autocomplete

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

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 (when the Option type is Component Picker): 

image-20240212-150247.png

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

image-20240212-150425.png

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

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