Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,948
Community Members
 
Community Events
168
Community Groups

How does one find a current list of all the broken filters and their respective owners?

Recently a custom field name in our JIRA environment was renamed.  As a result, its broken many people's filters. 

 

Is there a way you can identify a current list of broken filters and their respective owners?  That way individuals can update their filters accordingly without having to review all their filters one by one (this would be especially useful if people have over 100 filters).

2 answers

1 vote
Payne Rising Star Sep 06, 2022

If you have access to your database (or know who does), you can check the searchrequest table. In general, consulting the database directly isn't the best idea, but sometimes, in cases like this, it's warranted. You can use a query like

SELECT * FROM searchrequest where reqcontent like '%myfield%'

1.  In general, what exactly does checking the searchrequest table do?  What kinds of information does it provide?

 

2.  From the example query you provided above:

a.  What information would be displayed?

b.  Can you provide an example of a few lines of output that I would expect to see after executing the search?

 

Thanks.

Payne Rising Star Sep 06, 2022

Here is a sample result:

jira.JPG

okay thanks:

out of curiosity, how is this method different from this one?

https://community.atlassian.com/t5/Jira-questions/How-to-find-all-JIRA-filters-that-include-JQL-for-a-custom-field/qaq-p/732061

 

(It seems that the method you are suggesting is a lot simpler)

Payne Rising Star Sep 06, 2022

Though convoluted, at least one of those soluctions (Daniel Garcia's) does appear to work; Jonny Carter's does not work for me.

Some pros and cons of each:

Mine - simple and straightforward, but you need database access

Daniel's - you don't need database access, but you must have the ScriptRunner app installed.

0 votes
Bharathi Rising Star Sep 06, 2022

Hi @Raj Vora,

Unfortunately, there is no direct way in the Jira UI to locate such broken filters other than to manually check the filters. :( 

Suggest an answer

Log in or Sign up to answer