How to get all filter in jira server?

[Dang Thi Thuy Tien]

I want to get all filter, something like this table.

How can I do that?

Thank you,

[Alexey Matveev · Accepted solution]

Hello,

If you want to get all filters (even filters, which are not shared with you and private filters), you need to execute sql to your database:

SELECT s.filtername, s.authorname, s.DESCRIPTION FROM searchrequest s

[Dang Thi Thuy Tien]

Thank you @Alexey Matveev. In the table searchrequest i can find all information I want.

But I wonder, do we have any other way to get that information via java class?

Cheers,

[Alexey Matveev]

I think it is possible though I do not have a script.

[Dang Thi Thuy Tien · Accepted solution]

I found the solution for this question is: 

private final SearchRequestService searchRequestService;

ApplicationUser user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser();
searchRequestList = new ArrayList<>(searchRequestService.getOwnedFilters(user));

https://community.developer.atlassian.com/t/how-to-get-all-filter/26526/5

[Yassin]

Try out the free App "My Filter Manager for Jira" this can be used by admins to check the usage of certain fields in filters or filters owned by inactive users. 

https://marketplace.atlassian.com/apps/1224201/my-filter-manager-for-jira?hosting=server&tab=overview

[Yogesh Mude]

HI @Dang Thi Thuy Tien\

You can use the JQL to get all the filters.

like filter in (....)

[Dang Thi Thuy Tien]

I want to get all filter scheme ;)

Thank you

[Charly [DEISER]]

Hi @Dang Thi Thuy Tien

If you are a Jira administrator you can see all filters here: <your jira base url>/secure/admin/filters/ViewSharedFilters.jspa

Hope this helps!

[Alexey Matveev]

Private filters will not be in the list.

[Anthony Frank]

I am an admin at my company and it I can view Private filters using the above link.