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

Karthick Solaimalai

Hi,

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! 

Karthick

We are using Jira Cloud btw.

Andy Heinzer

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