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.
Atlassian Team members are employees working across the company in a wide variety of roles.
June 21, 2017 edited
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.