Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Does Sprint ID have a relationship with Issue Key in JIRA DB Schema?

Jira ril July 25, 2019

I was looking at JIRA DB Schema and found out that there is no linkage between a sprint ID and Issue ID.
According to the flow, Issues are part of Sprints/Linked with them.

I wanted to get sprint wise Issue data by leveraging DB without PLUGINs

1 answer

1 vote
Nic Brough -Adaptavist-
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.
July 25, 2019

No, the database contains no relationships at all, they are all done in the code.

"Leveraging the db" is the worst possible way you can report on Jira data.  You should stop it, and use the REST API (which will report issues in a sprint in one simple question/response instead of the six joins you'd need in a database)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events