Manage custom field values with a plugin or API

[Diogo Malheiro]

Hello, 

I don´t know if this topic was already raised somewhere within the community.

We have 4 different portals and in all of them we have to insert the name and the id of the employee that the issue refers to (we have almost 900 employees). This oblige us to consult the respective ID in an internal database before opening the ticket.

Is there anyway to connect our database (or at least any data file type) directly to JIRA to create a dropdown box with the respective data and maintain it automatically updated?

Thanks in advance.

Kind regards

DM

[Nic Brough _Adaptavist_ · Accepted solution]

I'd reach for https://marketplace.atlassian.com/apps/23337/elements-connect-external-data-fields?hosting=cloud&tab=overview to do this without doing any coding!

[Laura Campbell _Elements_]

Hi @Diogo Malheiro 

What kind of internal database are you using? For example MySQL or PostgreSQL? Or something else?

[Diogo Malheiro]

Hi Laura, 

The idea is to pick the data from our PostgreSQL instance. Or at least, from an excel export?!

KR

[Laura Campbell _Elements_]

PostgreSQL will work with the app Elements Connect like Nic suggested.