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
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
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