On this page:
You can only use JIRA's built in custom fields in JIRA Service Desk, the JIRA Issue Collector, Confluence's "Create Issue" dialogue, etc. If you would like to use a custom field from an app that retrieves its options from an external database, you're out of luck. You can not use any custom fields from apps.
That's where the Custom Filed Option Synchroniser app comes into play. Use any standard multi-value custom field, such as checkboxes, radio buttons, selects, etc. in the JIRA Service Desk form as you normally would. But instead of having to manually update the field options whenever the options in the third party database change, the Custom Field Option Synchroniser will update those options for you automatically.
Your company uses the following systems:
When employees have a problem with their computer they can get support through JIRA Service Desk. When opening an issue, the employees have to select the ID of their computer from a select custom field. Because there are hundreds of computer IDs and they do change frequently, this task is automated with the Custom Field Option Synchroniser app.
Before you can set up a synchronisation for a custom field, you first need to configure a datasource for your desired database. Find more information about configuring a datasource in Configure a Datasource.
Because the queries the app is able to execute are read-only, the database user you configure in the datasource only needs read access to the database.
To manage synchronisations click on "Option Synchronisations" in the left sidebar of the "Add-ons" tab in the JIRA administration. You need to have administration permissions to access this page.
You can now either add a new synchronisation or edit an existing one. The following information needs to be configured:
Choose the custom field you want to sync the options with. Any of the following multi-value custom fields are supported:
Once you've configured a synchronisation, the custom field can't be changed any more.
Choose the field configuration scheme you want to sync the options with.
Once you've configured a synchronisation, the field configuration scheme can't be changed any more.
Datasource of the database you want to synchronise the options with.
This is the value of the attribute "name" from the "Resource" element in JIRA's
SQL statement to query the database for selecting the data you want to use as options.
The query needs to return the following columns:
Cron expression to schedule the synchronisation. Default:
|Error Mail Address||Email address to send error report if any error occurs during synchronisation.|