add a jira ticket to an SQL Database

Question

Good Morning everyone,

i have a little question.

So, is it possible to export a Jira ticket in an SQL Database?

For example, i have an Ticket for my recruiting departmet which contains informations about the applicant.

They want to export the ticktet after finishing it to the MySQL Database to save the informations about the applicant.

Informations like prename, surname, address, mobile number and the mail-adress.

Are there any methods to to this ?

I hope you guys have some ideas or already have a solution for me.

Thank you for your help.

Charlie Misonne · Answer

I don't think there is a very straight forward way or plugin to achieve that.

You could use the ScriptRunner plugin and write a Groovy script where you connect to the external DB and write the custom fields values to that DB with an UPDATE SQL statement.

https://scriptrunner.adaptavist.com/4.3.19/jira/recipes/misc/connecting-to-databases.html#_connecting_to_external_databases

Nic Brough -Adaptavist- · Answer

Issue is closed is a great trigger.  Probably the best way to do this is with a post-function added to the "close" transition, one that can reach out to your database and run an insert or update as needed.  (A listener could do it too, but a post-function is easier and probably the best place for it)

You will need to write some code to enable this.  A good chunk if you want to write an app to do it for you, but if you have Scriptrunner, it's got functions in it that can make your coding really short (I know, I know, bit of an advert, sorry).  https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/connecting-to-databases.html has an example read of a database, it should be easy to change that into an "update" statement.

Kevin Schmidt_2tfkkb · Answer

The Plan is when the issue is closed.

* I mean, if the recruitment Departement closes the issue then it will be fine when those Informations will be pushed out to database

Thank you guys for your help