In Search, how do I list down all assignee worked in tickets till date?

[Sanket Varu]

I want to extract past resource data and would like to check all assignees worked per ticket so far, is there a way to do that?

I am aware of JQL filter `Assignee Was` but in my case, want to get columns in result to display all assignees for each ticket.

[Mariana_Pryshliak_Saasjet]

Hello @Sanket Varu 

You can try Time in Status for Jira Cloud, which generates 7 types of reports, including Time in Status and Assignee time report. 

So you will get the info about who has been an assignee to each issue and how long they have been staying in each status. 

It's definitely what you need)) 

I hope you find it helpful

Best regards, Mariana

[Mehmet A _Bloompeak_]

Hi @Sanket Varu ,

It is not a built-in functionality in Jira.

Our team at Bloompeak developed Status Time app for this need. It provides various reports and one of them is Assignee Time. It provides a report similar to the below format.

| Issue Key | Assignee1 | Assignee2 |
|   PBI-1   | 1 hours   | 2 hours   |
|   PBI-2   | 30 minutes| 1 hour    |

Here is the online demo link, you can see it in action and try.

I hope, you find this helpful.