Reporting on tickets that are moved from sprints..how to?

[Jeffrey Bistrong]

I am trying to create a report of all tickets that were in a sprint and moved to a new sprint. However, I haven't figured out how to do this.

One theory I have doesn't work, is to take advantage of automation for JIRA, and when a sprint value is edited to update another (hidden) and put an X in that field.

I can then build a report that shows all the tickets that have this value as marked off.

The above doesn't work well because I can't figure out how to only trigger the automation rule when the field is initially not blank and changes to any other value whether it is null or has some other value.

I am open to other theories on how I could accomplish this.

[David Laperle]

project = XXXX and Sprint in openSprints() and Sprint in closedSprints()

Wouldn't that work ?

That would give you the list of issues in the openSprints that were also in closedSprints?

You could also filter on the status to remove the ones that are close/resolved.