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

how can i get a database diagram for jira

Richard Sigrist Sep 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
Nic Brough [Adaptavist] Community Leader Sep 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

0 votes
Tiago Comasseto Sep 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 Sep 18, 2013

He's already been pointed at that.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in United States

Unofficial downtown meetup week of June 3 or 4?

Hello everyone!  It's been a while since Houston's had a Atlassian Community Event (formerly Atlassian User Group meeting) so I wanted to gauge interest in an unofficial downtown meetup after wo...

35 views 0 0
View post

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