display ticket's assignee history in a table

[Sam Tang]

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.

[Usman]

Hello @Sam Tang 

Jira Cloud does not natively support displaying or exporting assignee history for multiple issues in a single table view as shown in your example. The built-in "History" tab under the Activity section of each issue only displays the change log for that single issue. There is no built-in filter, or dashboard gadget that can aggregate and display the full assignee history for a list of tickets in a table format.

The community post here provided a few workaround you can explore - https://community.atlassian.com/forums/App-Central-articles/How-to-get-assignee-history-for-Jira-issues/ba-p/2511604

One option is the marketplace Addon - Issue History for Jira and another is a JQL to search for assignee issue history. 

[Sam Tang]

Thank you.

I don't need a table or filter in Jira to display the information, I would like to display in Confluence, just pull the data from Jira, but seems there is no such Field or information to get previous assignees.

Thanks

[Usman]

Yes you are right and as you have found out Jira Cloud does not provide a built-in field or macro that exposes the full assignee history for issues, so you cannot directly pull this information into Confluence using the standard Jira Issue/Filter macro.

The assignee history is only available in the issue’s activity log (History tab), and not as a field that can be queried or displayed in bulk.

[Yuliia_Borivets__SaaSJet_]

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.

[Petru Simion _Simitech Ltd__]

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

[Roma Bubyakin _Wombats Corp_]

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