Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

add a jira ticket to an SQL Database

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.

 

2 answers

0 votes
Charlie Misonne Community Leader Feb 15, 2021

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?

Yes you got it :D

In the best case it would be automated.

Charlie Misonne Community Leader Feb 15, 2021

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

0 votes

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?

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 

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you