JQL query for newly created issues since the last active sprint was closed?

Question

As a Scrum Master,

I want a dynamic JQL query to see all issues that have been created since the last active sprint was closed

so that I can gain better insight into recent scope increases for a project without having to manually change the JQL query date every time.

Thanks in advance!

April_Delay · Answer

Agreed, my customer wants to see the deltas of status change, and the status change since [time] doesn't include newly created issues.

plainclothes · Answer

3.5 years later, same issue here. This is a pretty common need and a long-standing pain point. I just came searching again assuming it would have been addressed by now 😞

unknown · Answer

Hi Prashant,

Thanks for the response.

Unfortunately there are several issues with the JQL query you provided:

1. There are instances where a newly created issue is assigned to a current or future sprint.

2. I want to see a list of issues without filtering by assignee since that can be empty or not necessarily the current user.

3. There could be times when I run the query, some of these newly created issues are already Ready, In Progress, or Closed.

My real issue lies in the following filter in my JQL query:

createdDate >= [closing date of most recent sprint].

Our Sprints close weekly on Thursdays. I have to manually change this date every time I run the query. Is there a way to have it dynamically reference the closing date of the most recent Sprint instead?

Thanks,

Ogden