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,
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
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in talking to 20 people planning t...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs