How can I generate a report on sprints that are planned for future work

[Alena Kislenko]

How can I generate a report on sprints that are planned for future work? So that I can see the name of the sprint, the tasks that apply to that sprint, the dates of the sprint, and the goal of the sprint?

[Mark Segall · Accepted solution]

Hi @Alena Kislenko and welcome to the community!

Short answer is you can't without some workarounds.  Sprint metadata is not available to JQL and thus not available to native dashboards.  What many people do is capture this information in custom fields leveraging automation.   It could look something like this:

Custom Fields

• Sprint Goal
  Type: Paragraph 
• Sprint Start
  Type: Date
• Sprint End
  Type: Date

Automation

• TRIGGER: Scheduled
  I choose scheduled because it allows for updates to the sprint goals, dates, etc. However, if you have a lot of issues spanning a lot of sprints, you could just go with a manual trigger and execute on an issue in a specific sprint.
  • sprint in futureSprints()
• ACTION: Edit Issue
  • Sprint Goal:  {{sprint.goal}}
  • Sprint Start: {{sprint.startDate}}
  • Sprint End: {{sprint.endDate}}

Again, the trigger in this example is based upon only dealing with so many issues so adjust accordingly.

[Alena Kislenko]

Thank you!