Extracting JQL filters through SQL query

unknown

Hello Community,

We are renaming 20 Jira project names in our global Jira instance. There are multiple Users Who saved JQL filters based on the Project names, by changing the names of Jira projects will effect the JQL filters.

Please help me with SQL query to extract all the JQL filters which used project names to create filter. 

Thanks in advance

Rajkumar 

Aron Gombas _Midori_

You can get the saved filters like this:

select * from searchrequest

Project are in the "project" table.

With these you should be able to compile the query you're looking for.