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

[Devendar Gangapuram]

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

[Tom Lister]

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?

[Devendar Gangapuram]

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.