We are planning to standardize client (custom field) values across all Jira projects to make it easy to run reports per client across the organization. We prepared a list of client values that we would like to change and want to proceed with the following steps:
1. Make changes to client values from the Jira UI.
2. Shut down Jira
3. Run DB queries to update all filters using the below template:
/* Template to update client values in all filters */
UPDATE SEARCHREQUEST SET REQCONTENT = REPLACE(REQCONTENT, '"@oldClientName"', '"@newClientName"');
UPDATE AO_60DB71_QUICKFILTER SET QUERY = REPLACE(QUERY, '"@oldClientName"', '"@newClientName"');
UPDATE [AO_60DB71_SWIMLANE] SET QUERY = REPLACE(QUERY, '"@oldClientName"', '"@newClientName"');
4. Delete cache from all app nodes
5. Start Jira
6. Perform Full re-index
7. Update workflows & Plugins configuration that use the client field
I want to make sure the steps listed above are safe and also I am not missing anything else that's important. Also, do let me know if you have any other suggestions for this exercise.
