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

[Ogden Rojas]

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!

[Prashant Mali]

Hi @Ogden Rojas ,

Welcome to Atlassian Community!

Could you please try below JQL. It will help to fetch only backlog issues in fliter.

issuetype = Story AND status in (Open, Reopened) AND assignee in (currentUser()) AND (sprint is EMPTY or sprint in closedSprints())

Thanks,

Prashant

[Deleted user]

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

[plainclothes]

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 😞

[April_Delay]

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