How to find filter that query on component name?

Question

We have defined a lot of filters in our projects, and those filters use different data from JIRA. Now we want to refactor the components, and it is pretty easy to rename them.

However, that does not change the reference in the filters that use the components in their "select" statement.

Is there a way to find all filters that "use" that component name somehow?

mliebelt · Answer

Thank you for your answer, but I would like to see something that could be done by users, developers or project admins. So they would be able to help themselves without the operation team (that has no time to do that for all users).

Mikael Sandberg · Answer

You could query your database for filters that are using the component you want to change. This query should work in MySQL

select * from searchrequest where reqcontent like "%component = <name>%"