Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I populate a custom field's select list from a MS-SQL table with JIRA in the cloud?

Michael Clarke
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 6, 2016

We have JIRA in the cloud and have a custom field with a select list of over 800 entries and growing.  I was wondering if there was a way to populate this table daily based on a table in our database?  I find lots of answers for stand alone systems, but need an answer for the cloud solution.

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 6, 2016

It requires code to provide a field type that can read another database. 

On Cloud:

  • You can't install the types of add-on that can provide that code
  • You can't install the database drivers they would rely on, or configure the Tomcat for them
  • You don't have access to the database

So it's a definite "no" for Cloud.

Hilal H Muhammed
Contributor
July 10, 2017

Just wondering if they have any new services to achieve this since it have already been an year since the original question was asked.

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2017

I'm afraid there's nothing new. 

Suggest an answer

Log in or Sign up to answer