how can i get a database diagram for jira

Richard Sigrist September 18, 2013

I have created several reports with Crystal Reports using an ODBC connection. I have produced reports showing the progress/status of Issues and it all works very well. I do not have a data base diagram to illustrate the connections between the tables.

At this time I am trying to use "links" to gather Issues that are linked to a specific Issue. In addition, I am trying to gather the History within an Issue to scan for specific events.

I would like a data base schematic diagram to make design of reports easier.

2 answers

0 votes
Tiago Comasseto
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 18, 2013

Hi Richard, perhaps this can help you to start: https://developer.atlassian.com/display/JIRADEV/Database+Schema

Cheers

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 18, 2013

He's already been pointed at that.

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 18, 2013

You asked this yesterday, albeit as a comment on another question. The answers there are still valid.

https://answers.atlassian.com/questions/11130/custom-reporting-and-retrieving-jira-data

Suggest an answer

Log in or Sign up to answer