Please excuse my ignorance of JQL but I've a pressing need to produce a very simple Sprint Report via the Issue Navigator, and I simply can't work out how to do it!
I want to be able to produce a very simple export to Word of the following fields, and nothing else, to enable Product Owners to simply cut & paste it into emails, to give clients basic visibility of what's being done and when.
So all of the Sprints, active and completed, in number order (eg Sprint 1, 2, etc) with dates, then the titles of Stories sitting under each one, with the Backlog and its Stories at the end:
After all the Sprints have been listed...
At present, every time we add/amend a Story or change a Sprint, a Word doc has to be manually updated, and this is proving very time-consuming! We're using Jira Cloud so a plugin isn't a solution...
If a JQL whizz could find the time to pen a script to do this, it'd be MUCH appreciated!
Many thanks in advance!
A JQL query can not produce a list of sprints. It can only produce a list of issues. You would need to select all issues, required by your requirement, export all these issues to an Excel file and then modify the excel so that you could see the report, which you want. You could also use Jira Rest Api to get info, which is not available in Jira issues (like if a sprint is active or not).
Calling all Confluence Cloud Admins! We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events