Ability to bulk edit JQL filters due to username changes

unknown

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_

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