nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to edit multiple filters to change a JQL value?

fbeck_br

Hello,

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[12345]

Is there some addon to change multiple filters at once ?

Should be possible to change these filters in Database ?

Accepted answers

Jaime S

Hi, Flavio.

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[12345]');

To avoid having to do this in the future. Other databases will probably use different 'replace' operations.

Be careful though!

If you have other custom fields with 'Address' in their names, this may break filters using them
Back up your database first! You may break something
Test it first. I didn't test those updated, not sure if I didn't make a mistake. Restore your backup somewhere else and test it there

I hope this was helpful.

Kind regards,
Jaime Kirch da Silveira
Atlassian Cloud Support

All comments

Jaime S

Hi, Flavio.

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[12345]');

To avoid having to do this in the future. Other databases will probably use different 'replace' operations.

Be careful though!

If you have other custom fields with 'Address' in their names, this may break filters using them
Back up your database first! You may break something
Test it first. I didn't test those updated, not sure if I didn't make a mistake. Restore your backup somewhere else and test it there

I hope this was helpful.

Kind regards,
Jaime Kirch da Silveira
Atlassian Cloud Support

fbeck_br

Great! thank you

SRBR SE

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

Joost Damen_whrvb3

Any ideas on this? @flavio beck were you able to solve this? i'm running into the same issue. Made changes in the Database (searchrequest table, reqcontent field) nothing changes in my filters in JIRA...

Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration