Is there a way to get data on who changed ticket status

Question

I'm looking for some way to output who moved a ticket
E.g. Who moved the ticket from status In Progress to Done
This person isn't necessarily the assignee

I can see the information in the ticket history, but do not know how I can extract it to enable some other automation through Zapier.

Thanks in advance

Bill Sheboy · Answer

Hi @Teng Bin Koay -- Welcome to the Atlassian Community!

Adding to Ollie's answer...

Automation for Jira is included with Jira Cloud.  To learn more about creating automation rules, please look here:  https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

Also, the specific user who performed some activity (such as transitioning an issue status), leading to a rule trigger, can be found with {{initiator}}  https://support.atlassian.com/cloud-automation/docs/jira-smart-values-users/#--initiator--

Kind regards,
Bill

Amay Purohit_RVS · Answer

Hi @Teng Bin Koay

Welcome to the community !!

You can use the Jira Rest API's to pull the issue history.

Or if you are open for a mktplace app, you can try out our add-on for better reporting capabilities and viewing multiple issues history at once,

Issue History Reports

You can view the complete change log for your filtered issues. The app has a "Who" column to show who made a change to the issue.

Disclaimer : I am part of the team which developed this app

Yuliia_Borivets__SaaSJet_ · Answer

I am not an expert, but I think you can extract issue status change history via REST API. You can read more in the discussion:

https://community.atlassian.com/t5/Jira-Software-questions/Download-status-change-logs-for-all-issues/qaq-p/1914990

or in the documentation:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-changelog-list-post

If you change your mind and want to try plugins, your case can be perfectly solved with the help of Issue History for Jira. The app shows what was updated (status or another field), who updated it, and when. It's free to try for 30 days.

+ you can export the report as CSV or Excel file

*the app is developed by my team