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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How can I query a ticket status as of end of the sprint?


I'm looking to create custom reports (using JQL queries) based on what was committed vs. delivered in a given sprint.  The problem I'm running into is how do I query for status as of the end of sprint (as it is displayed in the "Sprint Report").  As Jira tickets get updated even after the sprint has ended, how do I "freeze" the status of the Jira ticket as of the end of sprint?

Thanks in advance! 


We are using Jira Cloud btw.

2 answers

1 vote
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Oct 03, 2018

The sprint report is taking a snapshot of the issues and their statuses at that time.  To try to recreate this via JQL is a bit different, because issues can still change status and even been added/removed after the sprint is actually completed.

However since JQL does track historical changes to some system fields like status, you could probably use a JQL query such as

sprint="Example sprint name" AND status was "Example status name" on "2018/07/30 12:15"

But understand that this will only return issues to you in that are currently in that sprint AND that had this specific status at this specific date/time.  In this case, you would need to find the date/time that the sprint was closed and specify this in the JQL in order to see these results

Thanks for getting back to me.  👍 Technically your proposal can work; but we have 40+ scrum teams starting and stopping sprints on a weekly basis on different time/day and its going to be really tricky to pull this on a regular basis.  I will play with this a little bit more and come back to you here if I have any additional questions.

Thanks again!  🙏🏼

Any solution to this Karthick?

Did you ever find a solution for this? I'm trying to build a dashboard and I don't think I can put a JQL query as statistic type. 

Suggest an answer

Log in or Sign up to answer