display ticket's assignee history in a table

Question

Hello Atlassian Community,

I want to list out a table to display some tickets' assignee history, I know I can get the information via 'activity tab' for a single ticket, but I would like a list of tickets in a table like this :

Ticket ID, ticket summary, assignee history

ID-1          ticket 1           Tom > Jerry > Shannon

ID-2          ticket 2           Jerry > Tom> Shannon

ID-3          ticket 3           A> B> C

Can you please help?

Thank you very much.

Petru Simion [Simitech Ltd.] · Answer

Hi @Sam Tang ,

You can write your own script to extract this date.

There is no functionality of the shelf in Jira that will provide you this.

If you are open to using apps you can use Issue History Dashboard for Jira  an app provided by our company.

You can filter by Assignee then order your columns as you wish.

You can also export the result in CSV format for further analysis in Excel.

Regards,

Petru

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Sam Tang, @Usman, thanks for mentioning Issue History for Jira from my team.

Using this app, you can create a report like the one below. You can export it and also add it to Confluence via iframe.

Roma Bubyakin _Wombats Corp_ · Answer

Hello @Sam Tang,

As @Usman mentioned, there is no out-of-the-box solution.

I can propose our app that can do it (and A LOT of other things also) in Confluence:
User Macro for Confluence Cloud

For your use case, I have created an Issues Assignee History macro that does exactly what you ask. Here is how it looks on my page:

As a user input, it receives JQL, and it is also fully customizable!

Is it what you were looking for?

Regards, Roman
Founder of Wombats Corp