Is it possible edit multiple filters using JQL


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');


The customfield is updated, but only in my database. If i open some filter, the option Address is not update to Local Address.
I tried to stop and start the JIRA service, but is not working too.
Is there any alternative the update in real time?

1 answer

0 votes

That is NOT JQL.  JQL is for searching for issues.  You are running SQL, which you should NEVER use on a JIRA database.  I'd strongly recommend undoing the damage you've done and restarting again.

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)

ok, so do you have some idea how we can change (replace) multiples filters at once? Jira admin interface does not have this option. Is there some add on (free, of course)?

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.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,103 views 13 19
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot