It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Search Filter Queries for string

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.

1 answer

1 accepted

0 votes
Answer accepted

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. 

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you