SQL for filters using specific field

Davor Fisher

Hello,

I am looking *if possible* for a SQL (Postgres) that would give ma list of all saved filters in JIRA that are using a specific custom field within the JQL. 

 

Thanks

Davor

somethingblue

Hi Davor,

Hopefully you've found some help for this.  If not you can try the searchrequest table.  The reqcontent column holds the filters plain text so you may be able to start with a statement such as

select * from searchrequest where reqcontent like "%CustomFieldName%"

Cheers,

Branden