nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Solved issues from previous Sprints in Filter

Adam Kwietniak_fgoy07

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)?

Accepted answers

Jack Brickey

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.

All comments

Jack Brickey

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_fgoy07

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_fgoy07

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

filter

ms-excel

google-sheets