How do I create a JQL query that identifies or sorts the dates an issue was added to a sprint?

Philip DeLuca

Hi,

We are looking for a way to analyze work added to a sprint after it is started. The History of each issue records the date a user added the issue to the sprint, but I can't find a way to specify that I only want issues added to a sprint after a specific date.

I found the helpful ScriptRunner function:

addedAfterSprintStart("TheNameOfTheBoardYouWantToAnalyzeGoesInQuotes", "TheNameOfTheSprintAlsoInQuotes")

which lists all of the issues added after the sprint start.

Some of the issues it returns are from sub-teams that did their planning, but did not manually enter the tasks/subs until after sprint start (a practice we're working on eliminating). I don't care about those; the last expected work was entered by a specific date, and anything added after that is unexpected.

Alexey Matveev

Do I understand correctly, that after you filtered issues, which were added after the Srpint started, you also want to see the exact date in a column, when the issue was added?

If so, then as far as I understand you have Scriptrunner. You can create a scripted field which would return to you such a date. On the other hand you can not pass a certain sprint to a scripted field as a parameter (scripted fields do not receive parameters) that is why it could be a bit complicated or impossible to implement. Because the sprint field can contain several sprints but you need to see the date for a certain sprint. Everything depends on the logic of your Jira usage.