How to get a list of committed issues, added issues and removed issues?

Question

HI,

How to identify added, committed and removed issues when the sprint report is opened in Issue navigator and extracted in a CSV or excel file? I want to distinguish and bucket each issue into committed issues, added issues and removed issues and their corresponding story points.

Thanks,

Pooja

Pooja Wandile · Answer

Thanks Mark, will try with scriptrunner, but unfortunately we can't access database directly, hence exporting the data is the only option.

Mark Segall · Answer

Hi @Pooja Wandile - Put simply, there is no way to do this natively.  Here are the workarounds to consider:

* If you have a 3rd party app like scriptrunner, you could potentially create three different filters to cover your needs and export them separately.
* Copy/Paste the sprint report to a spreadsheet - I'd recommend copy/pasting in a raw format and then having another sheet that dynamically cleans it up for presentation
* Since you're on server, do something fancy with a data warehouse hitting the database directly

This has been a long requested suggestion, so I recommend voting for it here:

https://jira.atlassian.com/browse/JSWSERVER-20097