nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get all filter in jira server?

Dang Thi Thuy Tien

Screen Shot 2019-01-22 at 5.51.12 PM.png

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

How can I do that?

Thank you,

Accepted answers

Alexey Matveev

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

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

All comments

Alexey Matveev

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

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!

Yogesh Mude_u145qk

HI @Dang Thi Thuy Tien\

You can use the JQL to get all the filters.

like filter in (....)

Alexey Matveev

Private filters will not be in the list.

Dang Thi Thuy Tien

I want to get all filter scheme

Thank you

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

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

Anthony Frank_1mvyoo

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