How to retrive Sprint data from Database

[Venkata Sagar Ganesh Rao Mahendrakar]

Hi

Can we retrieve Sprint Data from Database.? 

May i know how can i retrieve.

Thanks

Sagar

[Trudy Claspill]

Hello @Venkata Sagar Ganesh Rao Mahendrakar 

What information about the sprint are you trying to get?

[Venkata Sagar Ganesh Rao Mahendrakar]

Hi @Trudy Claspill 

Sprint Name

Start Date 

End Date

Completed Date

Completed Sprints

Active Sprints

Thanks

[Trudy Claspill]

See if this article answers your questions.

https://confluence.atlassian.com/jirakb/determining-sprint-status-from-the-database-955177463.html

[Venkata Sagar Ganesh Rao Mahendrakar]

Hi @Trudy Claspill ,

Thanks for the article!!

But is it possible to see the relation of this table with the jira issue table ?

The end goal is to get the jira ID and the sprint name associated with it.

Thanks

Sagar

[Trudy Claspill]

Please clarify the problem you are trying to solve and your requirements.

Your original question was about getting sprint data only. You didn't say anything about wanting issue data.

Why do you need to get the information from the database? There are Sorint reports within the UI to show the Sprint information plus the issues in the sprint.

[Venkata Sagar Ganesh Rao Mahendrakar]

Hi Trundy

Thanks for the reply!!

The Main Goal is We wanted to retrieving data of Sprints along with Jira Issue id to Tableau Dashboard. 

Thanks

[Trudy Claspill]

This post from 2017 might help you get the issues related to sprints, from the database.

https://community.atlassian.com/t5/Jira-Software-questions/SQL-for-getting-all-issues-related-to-a-sprint/qaq-p/663162