Get list of Filters along with JQL using SQL query or Script Console

Question

Hi Guys,

Need your help in removing Shared plus Private Filters which are not in use or throwing error/not working means which are not active. Kindly suggest how can i get list of inactive filters using Script Runner or SQL query. We have 27k plus filters i want to remove unused filter or filter which are not giving any results.

Or want to list out all filters created by an inactive users.

Thanks

V.Y

Martin Bayer _MoroSystems_ s_r_o__ · Answer

Hi @Vikrant Yadav , I think you can use

* https://docs.atlassian.com/software/jira/docs/api/7.4.2/com/atlassian/jira/issue/search/SearchRequestManager.html#visitAll-com.atlassian.jira.util.Visitor-
* and you can work with https://docs.atlassian.com/software/jira/docs/api/7.4.2/com/atlassian/jira/issue/search/SearchRequestEntity.html

I didn't try it now but I've found some snippets we have used in the past...

Vikrant Yadav · Answer

@Martin Bayer _MoroSystems_ s_r_o__  Kindly suggest.

Thanks