How to find list of saved filters using certain custom field/string in JQL

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

The purpose of the article is to show how to find filters that make use of a certain string in their JQL query.

Solution

The table searchrequest contains filter details, including the JQL, which is stored in the reqcontent column. You can query the table and put a where clause in the reqcontent column for your desired custom field.

The sample query below will show all filters that make use of thestatusCategorystring in their JQL query.

1 2 select id,filtername,reqcontent from searchrequest where reqcontent like '%statusCategory%'

Replace the statusCategory portion if you are looking for a different string to search in JQL filters.

Updated on March 12, 2025

Still need help?

The Atlassian Community is here for you.