Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I extract tasks/stories worked by one person across all sprints ?

Vaidehi Rayate June 26, 2023

I need to view all the tasks assigned to one person (completed or otherwise) . I am having difficulty to filter and compile that information

3 answers

0 votes
Kathy Hart
Community Champion
June 27, 2023

Another variation, depending on what you are looking for, is to use the WAS operator instead of =. This will pull any ticket the person WAS ever the assignee for. 

You will have to switch to Advanced JQL (Switch to JQL) to use this expression and for some of those offered in the answers above as well. 

assignee was User

0 votes
Krupasindhu Nayak June 26, 2023

Hello @Vaidehi Rayate 

In the advanced JQL you can simple specify the assignee of the user you want to search.

assignee = <USER-NAME>

the above will show you all historical dates, if you want to restrict it to certain date then can use date filters such as 

assignee = <USER-NAME> and created >= -30d

give you last 30 days issues.

Further you can include other fields such as issuetypes, status based on your requirement 

Add required columns to export.

Screenshot 2023-06-27 at 3.19.48 AM.png

0 votes
Trudy Claspill
Community Champion
June 26, 2023

Hello @Vaidehi Rayate 

You can get all the tasks currently assigned to a user by filtering on the Assignee field.

In what way does that not satisfy your need?

Trudy Claspill
Community Champion
June 26, 2023

If you want to constrain it to only issue that were assigned to a sprint in the past, a currently active sprint, or a future sprint that has not started, then add this criteria:

sprint is not empty

Vaidehi Rayate June 26, 2023

It gives me information only for the current sprint, I want to see combined information from all past sprints as well

Trudy Claspill
Community Champion
June 26, 2023

Please show us how you are trying to view all tasks for the person.

Have you created a search to retrieve the data? If so, show us the search query you are using.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events