Reporting on issues added mid-sprint

[kate reeder]

Hi folks - we are using JIRA Software on a scrum board, company-managed project. I would like to be able to report how many issues were added to a sprint after the sprint start date. We consider these to have been added 'mid-sprint' and would like reporting to show us how often this is really happening each sprint. We're using Rich Filters (plugin) for our dashboard reporting. 

For the JQL I can specify the Sprint and createdDate ...and am thinking I should search based on createdDate greater than Sprint Start Date... but I'm not sure how to specify the sprint start date in the JQL. 

Out-of-the-box, JIRA already gives users a pop-up message when issues are added to a sprint after the sprint was started, so JIRA must be calculating this somehow already. I don't know if this is as simple as a JQL query string or if some custom field(s) or custom development would be needed to achieve the desired reporting results.

[Trudy Claspill · Accepted solution]

Hello @kate reeder 

Jira does not natively allow you to compare two fields within an issue and use that directly as criteria in a filter.

Jira also does not natively have a function you can use in filters to identify issues added to a sprint after it starts.

If you are open to third party apps, there are several that extend JQL filter capabilities to allow you to compare fields within an issue, and at least one that has a function for retrieving issues specifically added to (or removed from) a sprint after it starts.

A couple of these that are mentioned in other posts are:

Adaptavist ScriptRunner 

JQL Search Extensions

These aren't the only such apps, but either one could work for you.

[kate reeder]

Thanks, @Trudy Claspill I did see some older posts indicating the same sentiment, but they were a few years old so I was hoping maybe new functionality had been added since then. Too bad it's not native, but the plugins I've worked with so far have been good solutions so I will look into that. thank you for taking the time to respond!!