Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

1 vote

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

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

342 views 23 8
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