A way to determine filters that use a project name

Question

I'm looking into changing a project name in our system (it is our most heavily used project, so tons of issues and filters), any way to see what filters are using this project name, so I can anticipate and minimize the potential impact of breaking these filters? Thanks.

unknown · Answer

thanks Boris, plugin seems to work.

Boris Georgiev [Appfire] · Answer

Here're some options:

* If you have a staging/test instance which is a clone of your production instance -

* Install Integrity Check for JIRA
* Rename the project.
* Run integrity check (the one provided by the add-on not the JIRA built-in one) - you need to check the "Check Filters" option
* The add-on will show you a list of all broken filters which refer "missing" projects and this list will include all the filters that use the "old" project name

* Do it via SQL query agains the JIRA database

select * from searchrequest where reqcontent like '%My Project%';