How do i update resolution at DB level, using sql scripting.
there are some resolutions - lets say - A, B, C , D and i want all of them to be changed to resolution "closed", so i wrote this query -
update jiraissue set resolution = 7 where resolution in (select id from resolution where pname in ('A', 'B', 'C', 'D'));
7 is the resolution id of closed. But this query seems to have done something wrong as on my dashboard now i can't see the project list anymore.
Please share your opinion.
You could well have damaged your database, but, to try to rescue this case, restart Jira and then run a full re-index
If you change data in a Jira database, then there are three basic rules
In the long term, if you need to do this again, then:
yes i know about jira.editable wrokflow status property, but the change was reuiqred across multiple projects thus I didn't want to make changes in diff. workflows or use global transitions that loop back on the same status just for the sake of updating workflow but I guess as the KB article suggests it's one of the few workarounds available.
My opinion is to avoid messing with the DB directly! I would use Jamie's script runner plugin which has a built-in script to bilk-edit resolution...
directly updating DB is not suggestable, always first try to update through jira api in case it is not feasible then you have to look into update directly on DB,
one way, you can update resoulution by using bulk edit
another way, check the following document to bulk edit resolutions
some one already raised an issue with atlassian
Using bulk edit isn't the best possible approach as the final workflow state is non-editable, ofcourse we can make it editable but the thing is that this change needs to be implementated across multiple projects. Thus updating each and every workflow isn't a great idea.
Modifying each workflow is a pain, you're right but once you get the time here's sth. I did with all my workflows:
I replaced the jira.issue.editable property with the following:
jira.permission.edit.group = jira-administrators
That way the issues aren't editable for any users but I can do whatever I want and I have to do bulk-edits A LOT.
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