Hi there,
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!
Hello,
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).
Thanks for the clarity, Alexey! I'm disappointed, but not surprised...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.