Reporting on issues added mid-sprint

Question

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 P Claspill · Accepted Answer

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.