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.
It started as any story starts, on a normal, rainy day. Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...
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