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 can you report future sprints with JQL code in confluence? Edited

I would like to set up pages in confluence for 2020 so that the sprint data can be extracted automatically from Jira and displayed. For example,

- sprint 1 2020 would be Jira data from week 1 & 2 e.g. resolved tasks.

- Sprint 2 2020 would be Jira data from week 3 & 4 and so on.

e.g.  project = aktsql AND Sprint in (51-52,2019)

My question is, is there a way to do this with just JQL so that issues can be reported with the week number and year in confluence? 

I would really appreciate any guidance with this from the community!

1 answer

Hi, @Ami !

You can get all issues from future sprints by this JQL:

project = DEMO and Sprint in futureSprints()

 But if you want to see exact sprints, firstly you should create sprints on Jira Board and then show issues in Confluence by Sprint's Name by this JQL for single Spring:

project = DEMO and Sprint = 53 

 and this JQL to get issues from different Sprints:

project = DEMO and Sprint in (53, 54) 

Hi Ben, firstly, thank you for taking the time to write an answer :)

Unfortunately, the problem is that future sprints are not named yet as they have not been started. Which is why I was wondering if it was possible to automate them with the week numbers instead as they will start and end on the same week of every month in a year.

I have been able to report sprint data as follows, but would like it to report from the weeks instead so it can be automated:

project = DEMO AND resolved >= 2019-10-14 AND resolved <= 2019-10-28 

But I would like something like this:

project = Demo AND Sprint in (futureSprints(w1-w2,2020))
project = DEMO AND Sprint in (ClosedSprints(w1-w2,2019))

 To the best of your knowledge, do you know if this is possible? :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

269 views 9 6
Join discussion

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