Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to get all filter in jira server?

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,

5 answers

2 accepted

1 vote
Answer accepted

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

Thank you @Alexey Matveev _cPrime_. 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,

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

0 votes
Answer accepted

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

0 votes

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!

Private filters will not be in the list.

Like Dang Thi Thuy Tien likes this

HI @Dang Thi Thuy Tien\

You can use the JQL to get all the filters.

like filter in (....)

I want to get all filter scheme ;)

Thank you

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you