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".
I'm using this JQL:
update searchrequest set reqcontent = replace(reqcontent, 'Address', 'Local Address');
I'd still avoid it - you've already discovered that it's not working. I think it should work in theory, but I'd also say you absolutely have to have the system offline. There's only one minor thing I would change with SQL in a running JIRA (and I don't need to since 6.1)
I'm afraid not any easy ones. At a glance, Jaime's SQL should have worked, if you do it on a shut-down JIRA, so that may be worth a look. (Sorry, my original answer should have included "an active jira database"). But as it's not done anything at all, that suggests that there is an issue with it. The other trick might be to try it with the script-runner addon. You could do the filter updates with that, but I'm less sure about finding them.
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