You should not update custom field values using Database. You can use bulk change functionality in Jira UI. You can read more here
I guess there is the jira.issue.editable property for the closed status in your workflow. Change the property to jira.permission.edit.group.1 with value jira-administrators (I guess you are a Jira administrator?). Publish the workflow and you will be able to bulk change the issues.
Atlas Camp is our developer event which will take place in Barcelona, Spain from the 6th -7th of September . This is a great opportunity to meet other developers and get n...
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