We have an issue in our Jira instance which has been closed but the resolution has not been set, and our workflow does not allow us to reopen that issue.
So is there any possible issues which could occur while updating the resolution directly in the database WHILE Jira is running?
I have tested this several times in a test environment, and the resolution is successfully updated (but not the search index). And when I performed a reindex, the searching was also updated with the new resolution.
>So is there any possible issues which could occur while updating the resolution directly in the database WHILE Jira is running?
You could destroy a chunk of the project. I've only seen it happen a couple of times, but direct modification of the issue table while Jira is running can lead to a LOT of serious damage (although I'd expect resolution to be moderately safe, I've seen catastrophic loss caused by updating other fields I'd have said were moderately safe as well)
Stop your Jira before using SQL to amend stuff!
I would advice against making manual changes in your DB for such a reason. Instead, create a transition in the relevant workflow, from the current status of the issue, TO the current status of the issue. As a postfunction in that transition, set the resolution field value to whichever value you want it to have. Now, navigate to the issue, perform the transition you have just added, and your resolution will have changed. Regarding the editing of closed issues in general, please have a look at this product documentation.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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