How to (bulk) change resolution of already closed issues

[pooja chourasia]

Need Help !!

To bulk change a number of unresolved issues across a number of projects.

I need to update is as follows:
Any issue that has a status of "Closed" and a resolution of "Unresolved"
Then
Update the resolution to "Completed"

Please suggest.

[Julian Governale · Accepted solution]

I know this is old but i had this issue and our process to resolve this is below.  This has worked pretty well for us since we had over 1000 issues that were a status of Close but resolution of unresolved - frustrating when trying to report on closed issues with this case.

1. isolate the issues that are in closed status but unresolved (or what ever your case is)
2. (Optional) Export to excel to understand the scope of the issues / projects impacted
3. For this example, its all under one project 
4. Review the workflow for this project and on on the Close Status, tick the box to allow all issues to transition to this status
5. Add a post function to this transition to set the resolution, in this example to Done
6. Bulk change the issues that are unresolved but a closed status
7. Transition the issues
8. transition all the issues to close (Yes you are going Close to Close, all we want is that post function to run)
9. Send the email if you like but since the end users expects these issues to be closed, i uncheck this
10. Confirm and update the issues
11. Review that resolution is now set.
12. Go back into the workflow and remove the option to transition all issues to close.
13. Publish your workflow and should be good to go. 

Caveat: resolved date and time is the Bulk update date and time so keep that in mind. 

[André Matzke]

this accepted answer does not work.

If you try to add a transition in a workflow for "status 1" to "status 1" it responds with : "you cannot do this if youre in draft mode" .. so you stuck, because you need draft mode to add such a transition. So it seems Jira is broken ?

[Rafa]

@André Matzke actually, it works : )

The official documented workaround asks you to make new outgoing / looping transitions. And that you cannot do, as you say, because you get the "not in draft mode" error (the workaround to that workaround is to clone the workflow, edit the new one, and move the tickets to the new workflow on the workflow scheme.. a mess).

But @Julian Governale 's trick is to simply edit the Status: "tick the box to allow all issues to transition to this status". This way you don't create a new looping transition.

Such a simple solution! After years of not bothering to clean up old unresolved tickets (because of the convoluted and flawed "official" steps needed), I finally resolved them now.

Remember to edit the post-funtion on the "all" transition to set the Resolution.

PS: jira being jira, if you have different workflows for different issue types, you will have to do the bulk edit for each issue type separately, because it only let's you choose one transition within one workflow (instead of letting you choose the transition that is appropriate for each issue type)

[Michael Hagesfeld]

Additionally, the "Open workflow in new editor" removes the Draft issues.

[Rafa]

True, noticed that a couple days ago and wanted to find this thread to add this "tip" as well : )

However, after editing the workflow in the new editor, the old editor still had the previous version (the new loops only appeared in the draft, and it wouldn't let me publish it); you end up in this weird situation with two versions of the saved workflow. If you make new changes on the old editor and publish, the "loop" changes made in the new editor disappear. I think I solved it by eventually making a copy anyway, as I was cleaning some messy workflows. But as a temporary quick fix, it worked perfectly.

[Thomas Deiler · Accepted solution]

Dear @pooja chourasia,

you will need the 'Edit' and 'Resolve' permission on all the projects, where the issues are located.

Then JQL

status = "Closed" AND resolution is EMPTY

Then right upper area 'bulk change', you only see this, if you have the global permission 'bulk change'.

It is possible, that you can only change the first 1000 issues - it's a hard limit. Just repeat the steps to get all.

So long

Thomas

[pooja chourasia]

Hello Thomas,

Thanks for the quick response,

and I can see 'bulk change' option.

[Thomas Deiler]

Dear @pooja chourasia,

does it work?

So long

Thomas

[Thomas Deiler]

Can you pick one random issue and see if you could edit the resolution? (Not Bulk)

[Henning Tietgens]

Normally, the Resolution should not be part of the Edit screen. So only performing a transition could lead to the desired outcome.

[Thomas Deiler]

Sure, but when the user has a set of issue over many projects, I doubt that they all have the right transition which allows settung the resolution.

By checking the edit screen, we can just see if the user "can" set the resolution.

[pooja chourasia]

Hello Thomas,

I have added new transition and set resolution for it. It worked fine.

Thank You :) 

[Thomas Deiler]

Don't forget to accept one or both answers, if they were useful to fix your problem.

Thanks

Thomas

[pooja chourasia]

Sure Thomas :)   

Thank You

[Henning Tietgens]

Hi,

Additionally to what Thomas wrote, you may have to adapt the used workflows to allow editing of closed issues if Edit is not available within bulk change.

In this case you have to check the workflow step properties, if they contain jira.issue.editable=false you have two possibilities.

1.  temporary remove the property to edit the issues
2. remove the property and add the new property jira.permission.edit.group=jira-administrators so that only members of the group jira-administrators are able to edit the issues (we did this for all our workflows)

Henning

[pooja chourasia]

Hello Henning,

Thanks for the reply,

Workflow transition has true value for the property 'jira.issue.editable', still I am unable to see any option to change the resolution for issues.

Also unable to edit issues.

Could you please suggest. 

[Henning Tietgens]

I think, even if you have edit permission for each issue in your list (in this case the Edit Issues bulk change step should be available), you will not be able to change the resolution because it's not available for bulk edit. Sorry, I didn't though about this before.

See here for possible solutions: https://confluence.atlassian.com/jirakb/howto-bulk-edit-resolution-321857142.html

Let me know if you have ScriptRunner available on your system and need some help with it.

Henning

[pooja chourasia]

Hello Henning,

This link has the solution, I have successfully implemented it and also worked fine.

Thank You :)

[Jakub Cieslak]

Hey, as an alternative, if you have global admin rights, you could setup a global automation to do the desired changes for you, example:



And once you are all set, execute the rule manually:

After that, I suggest disabling the rule, so it doesn't execute in the future by accident.

[Adina Pierce]

Genius...I did it on the project level, and this was much easier than exporting and importing