Solved issues from previous Sprints in Filter

[Adam Kwietniak]

Hello Community!

I have a little problem with the Filter. I'd like to export all issues solved by one person and export them to the Google Sheets or Excel file.
Problem is that, I can only find issues in active Sprint but not from the previous closed Sprints. How to find ALL issues solved by particular person (even from the previous Sprints) and download them as xlsx file (for example)?

[Jack Brickey · Accepted solution]

Hi Adam, welcome to the Community. Assuming the issues were solved in a Sprint then the following might get you there...

project = xxxx and assignee = fred and resolution is not Empty and Sprint not in openSprints()

start w/ that and see if it needs tweaking. this assumes that Fred is the assignee for all issues he resolved.

[Adam Kwietniak]

Sadly, I only see several issues.
I know that our "Fred" has done this issues and they're still assignee to him. Despite of the fact that they're done I'd like to export them as xlsx file (let's say, as a report).
I was trying to use "date" component and choose between "2012 to actual date". However, still the same problem. Issues in "done" column dissapeared from previous Sprints.

[Jack Brickey]

then let's debug...

find an issue that isn't showing but is desired and interrogate against the JQL...

• Is the resolution set? If not (unfortunate) then maybe change the resolution piece with "statuscategory = done"
• What is showing in the Sprint field? If none then you would need to include "...or Sprint is empty"

[Adam Kwietniak]

Okay so, I've got one particular issue.
You're right. It has "Sprint" as "None", because it shows only active Sprints.
Where do I find resolution?

[Jack Brickey]

so do you want issues to be included if "None" is in the Sprint or not? If you do then simply add the following to the above jql

"OR Sprint is Empty"

unless of course someone has create a Sprint called "None" (really bad idea) in which case you would add

"OR Sprint is Empty OR Sprint = None"

[Adam Kwietniak]

Okay, solved with your help, thanks!