Script for deleting filters

[Anuradha Yadav]

Hey,

We have some criteria for Filters to be deleted in our Jira Instance.
Could anyone help with Script in Scriptrunner for below?

We need to create a script that delete filters which fall under these criteria:

1. filters to be deleted which are owned by inactive users, private and with fav count 0
2. filters to be deleted which are owned by inactive users, private and with fav count 1
3. filters to be cleaned up which have Owners that are inactive and Filters are not shared/not favorited by any User )
4. private filters which is created by inactive users and Fav count <2. 
5. private filters which is created by inactive users and Fav count 2 & more. 
   
   

or any idea is welcome.

Regards,
Anuradha

[CJ Edwards · Accepted solution]

That is a pretty big ask.

I would start by reviewing this post

Jira questions Bulk-Delete-Issues-Using-ScriptRunner 

Work on a base from there and many of us can help beyond that.

[Anuradha Yadav]

Hi @CJ Edwards ,
Thanks but the post you gave is for issues right? not for Filters.

I tried below Script:
But seeing some errors. Could you please help?

[CJ Edwards]

Hi Anuradha,

I would work from the top of the script to narrow the problems.

-  getAllUsers() was deprecated long ago. Use UserSearchService.findUsers() use https://docs.atlassian.com/software/jira/docs/api/9.8.1/com/atlassian/jira/bc/user/search/UserSearchService.html

- for filter work use - com.atlassian.jira.bc.filter - Interface SearchRequestService

https://docs.atlassian.com/software/jira/docs/api/9.8.1/com/atlassian/jira/bc/filter/DefaultSearchRequestService.html

The error listed in your picture is from passing DelegatingApplicationUser instead of ApplicationUser that the function is expecting.

I hope this helps!

[Henrique Bittencourt]

@Anuradha Yadav 

Did you have success using ScriptRunner to bulk delete filters?

I'm working on a project where I need to delete all the inactive users's filters or delete them by their filter id.