How can you report future sprints with JQL code in confluence?

[Ami]

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!

[Alexander Bondarev]

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) 

[Ami]

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? :)