How to get the action history for an issue in JIRA

Question

I am looking for a way to get the history of actions (by name or ID) that an issue went throught. I have transition tab form JSU addon, but this don't show the names of the actions, just the chronology of status changes.

Thanks in advance,

Kneek Cnarly · Answer

Hi, can you please explain how this is can help? Because how i can see, changeitem and changegroup tables not contains any data about actions(transitions) id's or names.

Vasiliy Zverev · Answer

Try this one:

Select
	changeitem.OLDSTRING		as Status_was
	, changeitem.NEWSTRING		as Status_new
	, cwd_user.display_name		as Actor_Name
	, changegroup.CREATED		as Change_date
	, changegroup.*
from
	(Select
		changeitem.groupid
		, changeitem.ID
	from
		changeitem
	where
		changeitem.FIELD = 'status'
	) as onlyStatusChange
	join changeitem	on	onlyStatusChange.ID = changeitem.ID
	join changegroup
		join jiraissue	
			join project	on	jiraissue.PROJECT	=	project.ID
		on	 changegroup.issueid = jiraissue.ID
		join cwd_user	on	 changegroup.AUTHOR	= cwd_user.user_name
	on	onlyStatusChange.groupid = changegroup.ID
where
	project.pname = '' --enter name of a project
	and issuenum = 3 --enter issue number here
order by --change sort here
	changegroup.AUTHOR
	, changegroup.CREATED

Adolfo Casari · Answer

Hi, something doable from JIRA, but if that's not possible a query could help.