Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
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

How to create a dynamic search for future sprint issues?

Our JIRA board consists of several future sprints (Current active sprint + 4 future sprints). I would like to create a table in our wiki which lists all issues of each future sprint separately. At the moment my query for future sprints is more like hardcoded in terms of [sprint = "Sprint 12"], [sprint = "Sprint 13"] etc. So after a few weeks its not up to date and needs to be adapted.

Therefore i need a dynamic query like CurrentSprint () + 1, CurrentSprint () + 2 etc. Is it possible? 

Thanks a lot. 

3 answers

Hi @Jonas Linder

If you use this query it will show all tickets in future sprints

project = <projectname> AND sprint in futureSprints()

This gives all tickets for all future sprints.  To know which sprints the results are in,  I add a column in the results table to show which sprint it is and sort by sprint.  Hope that helps

Was this solved in any manner :) ? The Sprint | Sprint +1 | Sprint +2 | ... Overview?

project = <projectname> AND sprint in futureSprints() works really well however shows all the following sprints. I just want to see whats coming in the Next Sprint.

I'd also like to see something like; sprint in futureSprints() +1 

Is that possible?

I think the issue is more about what is characterized as 'next' sprint.  JIRA wouldn't know what you vs I consider our next sprint unless we say all sprints in logical order are the order of sprint sequences.

If that is the case then you could add an ORDER BY rank clause after your query project = <projectname> AND sprint in futureSprints()

 

@Jonas Linder will this option ^^ help?

Thanks for this @Amie Fudge. It makes sense, it is the case that the sprints are in logical order and thats what I want to display.

Closest I got was with ORDER BY rank was; project = <projectname> and sprint in futureSprints() ORDER BY Sprint ASC 

However this still includes other sprints, so its not exclusive to one.

Thanks

@Amie Fudge: Thanks. Our sprints are in logical order as well but my intention was to create something like an overview-table in wiki to plan all future sprints. Therefor i would like to fill each column with one future sprint (column 1 = future sprint 1, column 2 = future sprint 2 and so on).

@Jonas Linder sounds like a plan but is that just a duplication of the Backlog board?

Its a duplication but with additional information and the dependences are better visible if the future sprints are arranged side by side than among each other. Or maybe there is another view of the backlog i know?

You could also do this in portfolio plugin from Atlassian.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

226 views 7 7
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