You could try to get previous status using this SQL:
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
That will get you the data you need to recreate it. Do NOT try to "roll back" with this though. Status is not a simple "field"
You need to put the old workflows (or similar ones) back in place, and then transition issues back trhough the workflow to where they should be, using the data given by this SQL. Bulk edit will help you with that.
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot