creating sprint report from database

I'm going to start with "yes, I know that a sprint report is a click away in the JIRA interface," but I'm building a dashboard of other reports for our executives, using a third party reporting platform and I'm trying to find where in the JIRA database will show the issues that were added after a sprint started or if I just have to compare specific dates myself and which dates those would be. Does anyone have an idea on that?

3 answers

This widget could not be displayed.
Gonchik Tsymzhitov Community Champion Nov 04, 2017

Dear Rob,

in this thread has been answered how to fetch data and you can extra condition with time to add.

https://community.atlassian.com/t5/Jira-questions/Get-issues-by-sprint-from-database/qaq-p/422957/jump-to/first-unread-message

 

Cheers,

Gonchik Tsymzhitov

I saw this thread, but this doesn't give the particular detail I'm looking for, which is which issues were in the sprint when it started and which issues were added to the sprint after it started.

I had reviewed that thread, but as the proposed solutions did not answer the question, it seemed like it would be less helpful. I've gotten as far as the commenters, but I guess I was wondering whether there was a marker aside from a date comparison. I guess not, so I'll have to work that out.

This widget could not be displayed.

Sorry for off-topic, but much more easy to retrieve all you need for a report by JIRA Java API or JIRA Rest. Why SQL?

We've selected a third-party reporting tool that pulls information directly from the database and allows us to merge data from multiple sources across the company, not just from JIRA.

This widget could not be displayed.

I'm pretty sure I figured it out. I have to compare the date of the CREATED field in the changegroup table where the changeitem FIELD is Sprint, with the SPRINT start date. If the start date is earlier than the created date for the sprint change, it was added after the sprint started.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

220 views 3 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you