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

Mysql datatbase documentation

Is there any features to ocment the mysql database in jira

3 answers

0 votes
Daniel Ebers Community Leader Dec 28, 2020

Hi @shashank_bhuvanala

could you please add details what you are trying to achieve?

You either could be understood in a way you want to connect Jira to a database, then the following guide should help you get started:

In case your question is if you can display data from a MySQL database in fields of an issue - yes. There are Apps, like Script Runner which can provide a "Database Picker":
https://scriptrunner.adaptavist.com/6.15.0/jira/script-fields/database-picker.html

Please let us know if you meant something else.

Regards,
Daniel

No, 

We are developed a web application in php(Laravel) along with mysql datatbase.

We are planning to use jira for the same web apllication for enhancements.

So we already have the mysql database along with data.

For the same database we done documentaion using third party application "dataedo".

So as planning to shift to jira, is there any fetaure such as dataedo for mysql database documnetation.

The documentation basically tells about the database tables and their scehams and their descriptions.

Can you please help me on this.

Daniel Ebers Community Leader Dec 28, 2020

If I understand you correctly you are aiming towards a solution like "dataedo", but something for Jira (an App). You could always check https://marketplace.atlassian.com but I suspect the better tool to do it would be Confluence.

Please also see:

The good news is: Jira is pretty flexible, so with some effort you could still reach your goal. But you would have to check with you team if it is the suitable solution.

You always can use a trial license to have a look around and check if it meets your needs (same applies to Confluence).

0 votes
JimmyVanAU Community Leader Dec 28, 2020

Hi @shashank_bhuvanala

Welcome to the community. To add to Daniel's answers, have a look at:

https://developer.atlassian.com/server/jira/platform/database-schema/

The first few links provide pdf links for the database schema of Jira, which is what I think you're interested in. Note that it only goes up to Jira 7. It is likely that you are running Jira 8, in which case the consequent jar's would be helpful. In the UPM (Universal Plugin Manager) for Jira, upload the jar's. This will then allow you to generate the latest database schema.

This is very helpful too if you have additional marketplace apps installed. The app will also describe the active object (AO) tables where app data is stored.

Hope that answers your question!

Cheers, Jimmy

0 votes

Please note that there is very little use for having the Jira database schema.

You can not write to a Jira database with an external application, and reading it is ugly, complicated, slow and because most of the logic is done in the application, it often doesn't have the data you want.

Whatever you are doing, please, use the REST API to read/write Jira, not the database.

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