Search Filter Queries for string

[Patrick Chen]

Hi, I am wondering if there is a built in function or add on that address the following scenario:

When a Field Value is edited, Jira Filter Queries that reference the original Value's friendly name will break.

We would like to be able to search all the Filters/Queries in our instance so we can make the appropriate edits to the Queries after making the change, because sometimes it not as obvious that a Filter Query has broken down.

Additionally, if we can search if that Field Value is being used in Workflows.

Is there anything that can meet this need? Else, is there a place we can query in the database to achieve the same result? 

Any guidance is appreciated.

[RianS · Accepted solution]

The only way I can really think to do this with the standard Jira is by searching the database:

For search filters:

SELECT * FROM searchrequest WHERE reqcontent LIKE '%SEARCHTERM%';

Which will return the name of the filter, author, and owner where the SEARCHTERM exists in the advanced form of the filter (basic searches are stored with the advanced JQL formatting)

For  Workflows, this gets a little more tricky since the workflow definition is stored in the database an XML code block:

SELECT * FROM jiraworkflows WHERE descriptor like '%SEARCHTERM%';

This searches the XML definition looking for the SEARCHTERM value which if the value is a common term, may return erroneous results.

There are some other areas that might store JQL query information or field information as a text string. Board quick filters may have this info stored in the Jira Software tables and Service Desk queues store their definition in their own tables.

You can probably tweak these filters a little more to help with finding what you are looking for. Remember these searches are case sensitive so you may need to use a database function to make it case insensitive.