nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dropdown Select from External Database in JIRA Cloud Service Desk

Peter Androutsos

I am trying to figure out if there is a way for me to create a custom dropdown select field for which the options in the dropdown are pulled from an external database. We have a list of options which are always in flux (service locations), and consequently, it would be a full-time job to keep the locations in JIRA up-to-date. I would like the service desk portal to simply display the always-up-to-date locations from a dropdown that is pulled from a live database (direct to mysql, or i can create a json resource via http).

Alternatively is there maybe a way to procedurally update a custom dropdown select field's options? Perhaps a REST endpoint? I could easily write a cron script to perform the update every X minutes or on demand whenever a change to the location list is made.

There are plenty of options for pulling data when running JIRA Server, but we are somewhat devoid of options when it comes to JIRA Cloud. Makes me want to give up on Cloud.

Any ideas?

Accepted answers

All comments

Ismael Jimoh

To my knowledge the above is no way to create what you described.

An asset management tool like insight for Cloud is your best bet but I did not find any in the marketplace.

For the option of dynamically changing options of a select list, this is not possible in Cloud.

Ismael Jimoh

Found this https://marketplace.atlassian.com/apps/1213365/oomnitza-for-jira?hosting=cloud&tab=overview&_ga=2.52325098.238419106.1543173458-1481143411.1540476554

it may help with your request.

Thomas Opiolka - codefortynine

There is now a Jira cloud App called External Data for Jira Fields that allows to synchronise external data with a selection field.
You can easily connect a Json endpoint as a data source. The Jira selection field then updates periodically.
This should apply to your use case.

Disclaimer: I'm the product manager of this App.

Peter Androutsos

OK, but does this address the basic premise of the question? Can you have the dropdown select options for a custom field via a remote data source using this plugin? I want the options shown in the dropdown to be populated from a set of cached data so that I can choose one of those options which were in the remote JSON response. This should then be populated in the custom field. The cached data source should have the option to be updated on whatever schedule I like (e.g. every week, every day, every hour, every minute, every X seconds, etc). As far as I can see from the instructional video, this is not possible.

Thomas Opiolka - codefortynine

Yes it is possible. The feature is just new and not yet reflected in the video. (The video is a issue based example)

To fill an dropdown list you have to use "Selection" as ValueType then the custom field options of that field gets synced around every hour.

Peter Androutsos

As I an not familiar with JSONPath, how would I populate the dropdown options with a specific field from each set (say 'field2') using a set of data similar to what is show as below:

[

{

'FIELD0': '100',

'FIELD1': '101',

'FIELD2': '102',

'FIELD3: '103'

{

'FIELD0': '200',

'FIELD1': '201',

'FIELD2': '202',

'FIELD3: '203'

{

'FIELD0': '300',

'FIELD1': '301',

'FIELD2': '302',

'FIELD3: '303'

}

]

The result should be a dropdown which allows the user to choose from the following options:

- 102

- 202

- 302

Perhaps there is a better way to format the json output?

Peter Androutsos

Seems I am no longer able to get the API Token to work. I save a new token, but the system complains as follows:

Step 1: SUCCESS Save API Token

Step 2: ERROR Access eMail by Atlassian Account ID

I have tried what is suggested by the error message, and my email is visible to all.

Thomas Opiolka - codefortynine

Hi Peter,

sometimes it just takes some time until the email is available or to toggle the switch on and off.

Some customers with the same issue had to open a ticket with Atlassian, because it was an issue with the account itself.

If you need more information or have further questions please write to support@codefortynine.com

Best,
Thomas

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

jira

cloud

jira-cloud