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.

[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