How create queries using sprint informations?

[Luciano Borges]

Hi all,

I am newbie in Jira and I am using the Confluence to show to the boss the work of Scrum Team.

I'm starting Scrum on this team, but there was already a legacy of issues (bugs and new features) registered on the Jira which I'm considering as my initial backlog.

I need to create some queries that show me the following informations:

• Issues from previous sprints that were not closed (issues that automatically enter in the current sprint);
• Issues added in the sprint planning;
• Issues added after the start of the sprint;

          Obs: All of the above information is my Sprint Backlog.

• Issues that comes from previous sprint but were not planned for the current sprint (issues removed from current sprint or moved for future sprints);
• Issues closed in current sprint;

Thanks!

[Patrick Ricciardi · Accepted solution]

You can use JQL to get a list of tickets in open, closed, and future sprints some details here: Advanced Search and Searching Sprints.  I don't know of a way to get the information about when/how a sprint was added, though.

When tickets are moved from one sprint to another when a sprint is closed I believe they keep the label of both sprints. So, that is a way you could capture those tickets.

pat