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.
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?
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.
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event