Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

A simple JQL script to produce a list of just the Sprint names/dates & Story titles under them?

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:

  • Sprint name (active and completed)
  • Sprint date (from / to)
  • Stories (just the story titles, nothing else, in the order they appear on the Board)

After all the Sprints have been listed...

  • Backlog (just that title)
  • Stories (just the story titles, nothing else, in the order they appear on the Board)

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!

 

1 answer

0 votes

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...

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

⚡️NEW Group for Confluence Cloud Admins

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...

95 views 2 8
Read article

Community Events

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

Events near you