Ability to bulk edit JQL filters due to username changes

[Deleted user]

Hello,

is it possible to bulk change (database / addon / script) filter queries of saved filters and quick filters within jira scrum/kanban boards? We need to change usernames in our instance due to new naming conventions and therefore need to identify all filter queries that make use of the old username strings and change them.

Some one did this before and can provide an "easy" way to achieve this?
Probably more than 5000 filters affected...

Best regards
Christoph

[Fabio Racobaldo _Catworkx_ · Accepted solution]

Hi @[deleted] ,

in order to update filter containing old username you can try to use the following DB query :

update searchrequest set reqcontent=REPLACE(reqcontent, 'OLDUSERNAME', 'NEWUSERNAME') where reqcontent like "%OLDUSERNAME%"

For your quickfilters use the following one :

update ao_60db71_quickfilter set QUERY=REPLACE(reqcontent, 'OLDUSERNAME', 'NEWUSERNAME') where QUERY like "%OLDUSERNAME%"

My suggestion is to test it first in your test env and to perform a DB dump first.

Please, remember to restart JIRA after queries executions.

Hope it helps,

Fabio

[Deleted user]

Thanks I'll try that! Maybe I can automate this with the hundreds of uers affected.

[Fabio Racobaldo _Catworkx_]

Yes, you can @[deleted]  Btw, my suggestion is to try first just for one user