How to get the action history for an issue in JIRA

Adolfo Casari
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2016

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,

3 answers

0 votes
Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2016

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
Kneek Cnarly July 6, 2017

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.

0 votes
Adolfo Casari
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2016

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

0 votes
Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2016

is some SQL statement acceptable or you need something integrated in JIRA?

Suggest an answer

Log in or Sign up to answer