How to maintain a list of values for a labels type custom field, source is an external database?

[Mike Gourley]

I've created a custom labels type field for recording hardware serial numbers.  We like the labels type field for this because one click on the label on the view screen or in a dashboard will open a query for all issues with that label.  But now we want the custom labels fields, or similar, to present the user with a list of known values that is dynamically read from an external database that is maintaining the list of available serial numbers.  

[Rafael Pinto Sperafico · Accepted solution]

Hi @Mike Gourley ,

To connect to a DB, fetch data from there and display into a custom field please have a look at (just to mentioned a few, there may be other):

• Power Database Fields (https://marketplace.atlassian.com/apps/630415/power-database-fields-pro-external-data)
• Elements Connect (https://marketplace.atlassian.com/apps/23337/elements-connect-formerly-nfeed)
• Table Grid Editor (https://marketplace.atlassian.com/apps/1110050/table-grid-editor)

Alternatively, you could write your own script making use of ScriptRunner (https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira) to pull data into a particular field.

Kind regards,
Rafael

[Daniel Fietta]

Hey Mike,

Also check out STAGIL Database Sync!