Is there a way to tell when an issue was moved into a sprint.

[David Battersby]

I am looking at writing a report of Items that where moved into a sprint after the sprint has begun. I would like to have a query that shows the items in the sprint and the date it was moved from the backlog to the sprint.

Thanks in Advance

[Aron Gombas _Midori_]

Hmmm. I don't know the JQL and I think it is not possible with a single query.

Basically, you would have to search for the issues which:

• has the "Sprint" field set to sprint X
• and the change when the field was set to sprint X (you can get it from the change history of the issue) is after the start date of sprint X

I think you can:

1. get all issue that has "Sprint" set to X from the REST API using a JQL search
2. get sprint X from the REST API
3. iterate over the issues, look up the last change history when the "Sprint" field was modified and compare it to X's start date

So, not in CQL, but it is possible for a cloud integration.

[abhishek_sharma03]

Hi @David Battersby - You can know this info from the sprint burndown chart as adding a new story usually creates a spike in the trend line and you can see the time in the sprint when it was added. 

BR

Abhishek

[Frederik Vantroys]

I don't think there is an easy way with JQL to do this. The used to be a plugin JQL search extensions ..

But : you can see the if you want in the reports in Jira :

• They show with a * ("Issue added to sprint after start time") next to them in the Sprint Report.
• The Burndown Chart records this as a scope change with 'Issue added to sprint' in event detail.