How to get value from SQL and display on jira cusotm field

Question

Hi Team,

I need to get a value form SQL DB and display it on JIRA custom filed. SQL simple select query to get a single value.

Thank you

Devendar Gangapuram · Answer

Thank you @Tom Lister for the quick reply. I will do this and let you know in case of any furhter info if I needed.

Tom Lister_fo1j4e · Answer

HI @Devendar Gangapuram

There are notes from Adaptavist on accessing a database here

https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/connecting-to-databases.html

You are also able to set up a database connection as a resource

The exact mechanism as to how you get results into your field will depend on where you are planning to make the update e.g. in a post-function, in a behaviour?