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

[Raj Vora]

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).

[Payne]

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%'

[Raj Vora]

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]

Here is a sample result:

[Raj Vora]

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]

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.

[Bharathi]

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. :(