ScriptRunner/Groovy - Retrieve all saved filters and edit them

[elie_g]

Hi!

I would like to know if it is possible to retrieve all saved filters and edit each of them using a function like collect or each.

Thanks!

[Henning Tietgens · Accepted solution]

Hi,

yes by using the SearchRequestService (ComponentAccessor.getComponent(SearchRequestService)) you can retrieve filers, update and delete them.

If you want to retrieve all filters existing in the system you first have to retrieve all users (using the UserManager or UserUtil) and then retrieve all filters of each user using SearchRequestService.getOwnedFilters(). For the SearchRequest elements of the result you can use SearchRequest .query.queryString to get the JQL query. You can modify the SearchRequest and use SearchRequestService.updateFilter() to save the modifications.

Henning

[elie_g]

Thanks Henning!

With your help I've been able to update filters of a single user but I don't know how to retrieve all the users. I look at the methods of UserUtils and UserManager but the getAllUsers function is deprecated. Moreover, the description of getAllUser says that it retrieve the users I need, but I need all users without any exceptions.

So I assume I need to retrieve all users using JQL query but I dont have any idea of what JQL query would do the job.

Do you know how I can retrieve all the users?

This is what I've done so far:

def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def ctx = new JiraServiceContextImpl(user)
searchRequestService.getOwnedFilters(user).each{filter->
 def nQuery = searcher.parseQuery(user, getNewQuery(filter.getQuery().toString())).getQuery()
 filter.setQuery(nQuery)
 searchRequestService.updateFilter(ctx, filter)
}

[elie_g]

Nevermind I got it!

Using the global group, I did this to retrieve all users:

ComponentManager.getGroupManager().getUsersInGroup('jira-core-users').each {...}

[Henning Tietgens]

Yes, that's a possibility if you have a group with all users. If it's a one-time job, you could use deprecated methods, too. Deprecated means you should replace this method in your code because it may go away in future releases. Or you could use the UserSearchService:

import com.atlassian.jira.bc.user.search.UserSearchParams
import com.atlassian.jira.bc.user.search.UserSearchService
import com.atlassian.jira.component.ComponentAccessor

def userSearchService = ComponentAccessor.getComponent(UserSearchService)
def userSearchParams = new UserSearchParams.Builder()
        .allowEmptyQuery(true)
        .ignorePermissionCheck(true)
        .maxResults(10000)
        .build()
def allUsers = userSearchService.findUsers("", userSearchParams)

Just use a number higher than the number of your user for maxResults.

Henning

[Fredrik Forsberg]

This post (with scriptrunner code example) helped me. 
https://blog.isostech.com/searching-all-jira-filters-for-a-specific-string

[Diana]

hi @elie_g 

This might be a long shot, but by any chance could you share your full script? I've been trying to achieve the exact same thing, and follow the suggestions, but no luck. I was hoping to see maybe by each line where mine is wrong in comparison to yours if you still have it?

Thanks!

[Fredrik Forsberg]

Diana - this post (with code example) helped me:
https://blog.isostech.com/searching-all-jira-filters-for-a-specific-string

[elie_g]

Hi @Diana Gorv ,

Unfortunately, I don't work at the same place anymore so I don't have access to the script I had made. However, if you can share your script here maybe I or someone will be able to help you.

[Diana]

Hi @elie_g  thanks for replying back!

I have my script here in another question: https://community.atlassian.com/t5/Adaptavist-questions/How-do-I-bulk-edit-saved-filters-in-ScriptRunner/qaq-p/2141723

But I had thrown in the towel on this one. Although I was able to identify filters, I can't seem to make bulk edit. My team has decided to manually edit. But if others know, it would be a nice to have at this point.

Thanks!