SQl queries for agile

Eleveo Admin September 15, 2014

Hi,

I need to create our own reports based on JIRA and JIRA agile. Part of my report is in Agile sprint report, but I need to add more information to that and for that I need to know sql quesries.

I need to get from database:

  • sprints in epic (epic issue is not in sprints, only issues assigned to epic were)
  • all issues completed in sprint
  • all issue in sprint when sprint was started

Thanks a lot 

3 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Ollie Guan
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 26, 2014

issues were completed in sprint

sprint in closedSprints() and resolution != Unresolved

which wasn't and were moved to backlog.

sprint in closedSprints() and resolution = Unresolved



0 votes
Eleveo Admin September 16, 2014

i did sprints in epic select, but still looking for somebody who will tell me how can I find information which issues were completed in sprint and which wasn't and were moved to backlog.

 

Any help will be a much appreciated.

0 votes
Norman Abramovitz
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 15, 2014

This previous answer might assist you.

https://answers.atlassian.com/questions/96142

Eleveo Admin September 15, 2014

it's great but I still do not know how to get all issue completed in sprint.

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

TAGS
AUG Leaders

Atlassian Community Events