Can I run a JQL to find an issues original sprint where multiple values exist?

[Kim P]

We have a business process flow issue we're working through that is essentially a QA bottleneck.  When Dev is closing out a sprint and testing is not complete, the issue is moved into the next sprint.  Subsequently, some issues have multiple sprint values on them(some even 7 + values). 

Attempting to report on which issues were originally part of sprint A, when the Sprint field value has A, B, and C present. 

Is there any way to query this info? We have scriptrunner if that's of any use here.

[Hannes Obweger - JXL for Jira]

Hi @Kim P

if you're open to solutions from the Atlassian Marketplace, this should be easy to do with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including the ability to group issues by any issue field - including of, course, your issues's sprints.

This is how this looks in action:

Issues that are part of multiple sprints would be listed in all their sprint groups, so you can easily figure out what was in each sprint. JXL also comes with a number of sprint-related smart columns - i.e., issue data that isn't natively available - for things like an issue's first or last sprint, if that's interesting.

As you can see above, once you've organised your issues, you can work on them directly in JXL, perform various operations in Jira, or export them for further processing.

Any questions just let me know,

Best,

Hannes

[Trudy Claspill]

Hello @Kim P 

If you use this filter you will get a list of all the issues that were in Sprint A, regardless of whether they were in any additional sprints.

sprint = <sprint A name>

Does that not satisfy your need?

If not, please provide more information on what you mean by "issues were originally part of sprint A". Are you trying to get only the issues that were completed in Sprint A?