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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, something doable from JIRA, but if that's not possible a query could help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is some SQL statement acceptable or you need something integrated in JIRA?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.