add a jira ticket to an SQL Database

[Kevin Schmidt]

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.

[Nic Brough -Adaptavist-]

When would you want this triggered?  A regular sweep where something skims Jira for new info to add to the database?  Or from the other side - maybe when an issue is closed, it pushes data out to the database?

[Kevin Schmidt]

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 

[Nic Brough -Adaptavist-]

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.

[Charlie Misonne]

Hi Kevin,

Can you confirm my assumption or clarify?

You want to extract some data from a Jira ticket and put it in a MySQL database?
And that database is not the Jira database but a database built for storing personal information of applicants?

Should this be a automated process?

[Kevin Schmidt]

Yes you got it :D

In the best case it would be automated.

[Charlie Misonne]

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