Support for Azure SQL Database

[Sergio Govoni]

Hi guys,

I just created the custom field Customer, I have to populate that field by a query on an Azure SQL Database. Is it possible on Jira Cloud?

Thanks in advance!

Sergio

[Nic Brough -Adaptavist- · Accepted solution]

Ok, that's perfectly clear now, thanks!

There are a number of ways to do this.

The simplest one is a one-off import of customer values.  Jira doesn't have an administration import into custom fields, so you would have to script "export list from database, import into admin functions for the field".  In between entering them by hand and a script, you could also export the list to CSV, duplicate the column (this import needs two columns - summary and option value, but they can be the same data), import it into a temporary dummy project as a set of issues, with your custom field mapped to one of the columns adn "import new values" ticked.

The other option might be to look at one of the "database reader" fields.  These can take options directly from a remote database instead of having to do a one-off import.  There's a simple one in Scriptrunner, but "Elements connect" gives you a lot more options.

[Sergio Govoni]

Ok,

the best option for me is the second one, could you so kind to put here a link to the "database reader" fields documentation for implementation ?

Thanks

[Nic Brough -Adaptavist-]

I'd generally look to https://marketplace.atlassian.com/apps/23337/elements-connect-external-data-fields?hosting=cloud&tab=overview first, but do check the marketplace for others!

[Juliette Lallement _Elements Apps_]

Thanks @Nic Brough -Adaptavist- for recommending Connect! @Sergio Govoni feel free to reach out if you'd like help configuring your use case! I am the Product Manager of Elements Connect and would be happy to help

[Sergio Govoni]

Thanks @Nic Brough -Adaptavist- and @Juliette Lallement _Elements Apps_ for your help!

This afternoon I tried External Data for Jira Fields and it seams to be good for our use case, anyway I will let you know about the final solution we will decide to use.

Thanks again!

[Nic Brough -Adaptavist-]

Ok, that's exactly what I was looking for when I asked!  Thank you for the clarification.

I'm afraid it leads to another question though:

Do you mean you want to copy some data into an issue's field, or make the list of customers into options in a select-list?

[Sergio Govoni]

Hi Nic,

no problem for any additional questions, I'm here :)

I would like to have a list of customers into options in a select-list.

In the following picture you can see our Customer custom field and Centro Software is the only option to select today (the customer Centro Software has been inserted manually).

I would like the list of our customers here.. the customers are in a table on Azure SQL DB.

Thanks

[Sergio Govoni]

Hi Nic,

>>> Do you mean you are trying to create something that will copy data that users on Jira enter into an issue into a remote Azure database?

I would like to do the contrary, I have a list of customers on a remote Azure SQL Database and I have to put that list in a Jira custom field.

Thanks

Sergio

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

You don't have access to the Jira Cloud database (and it's not on Azure anyway)

Do you mean you are trying to create something that will copy data that users on Jira enter into an issue into a remote Azure database?