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.
Was this helpful?