Suppose I have a user who has 150 filters. Some os these filters (I do not know how many) are using a custom field "Address", but we need to change the CF string to "Local Address".
We know that some user's filters will became broken because it use string instead of cf
Is there some addon to change multiple filters at once ?
Should be possible to change these filters in Database ?
If I'm not mistaken, database manipulation is the only way.
You can change the 'searchrequest' table for that. Using some operation for replacing is useful. For example, if you're using postgres, something like this should work (check it before using):
update searchrequest set reqcontent = replace(reqcontent, 'Address', 'Local Address');
Or even better:
update searchrequest set reqcontent = replace(reqcontent, 'Address', 'cf');
To avoid having to do this in the future. Other databases will probably use different 'replace' operations.
Be careful though!
I hope this was helpful.
Jaime Kirch da Silveira
Atlassian Cloud Support
Hi, Jaime. i made some updates in 'searchrequest' table and the changes are not working in my filters. The customfield was updated in Database but when i open my saved filter, the old option are still there. I tried restart JIRA but did not work Is there other step or suggestion to execute? Thank you
Yes, it do worked for me, but for some reason the searchresults may have some cache in mamory, and after change table entries it is not applied on JIRA application.
You need to restart.
Or, In my case I planned to do it in a maintenance window, so I only changed the database, but do not restart.
Mysteriously, in the next day morning (without any restart) the changes in DB was applied.
Maybe JIRA had cleared cache ..
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
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