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: * filters to be deleted which are owned by inactive users, private and with fav count 0 * filters to be deleted which are owned by inactive users, private and with fav count 1 * filters to be cleaned up which have Owners that are inactive and Filters are not shared/not favorited by any User ) * private filters which is created by inactive users and Fav count <2. * private filters which is created by inactive users and Fav count 2 & more. or any idea is welcome. Regards, Anuradha

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; } } }

Script for deleting filters

Anuradha Yadav_72cdka

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:

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

or any idea is welcome.

Regards,
Anuradha

Accepted answers

CJ Edwards_csqjr8

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.

All comments

CJ Edwards_csqjr8

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_72cdka

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_csqjr8

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_u5f51o

@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.

Rolf Lader_cy8ul1

Hi folks

I have realized a similare case by using the following console script

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchRequest
import com.atlassian.jira.issue.search.SearchRequestManager
import com.atlassian.jira.user.ApplicationUser
import org.apache.log4j.Logger

Logger logger = Logger.getLogger("script.console")

/*
* This script removes shared filters using a list of filter ids (as long).
*/

//
// Define the 'manager(s)' before we can de configuration (!)
SearchRequestManager searchRequestManager = ComponentAccessor.getComponent( SearchRequestManager )

//
// Configuration: Define an array of all 'shared filter ids' which should be deleted.
long[] sharedFilterIDs = [17638, 18168, 18509, 18623]

// Remove all 'shared filters' if they does exist.
sharedFilterIDs.each { long sharedFilterID ->

  SearchRequest sharedFilter = searchRequestManager.getSearchRequestById( sharedFilterID )
  if ( sharedFilter != null ) {

    // Delete the 'shared filter'
    logger.debug "The filter '${sharedFilter.getName()}' (${sharedFilter.getId()}) owned by '${sharedFilter.getOwner().getDisplayName()}' is deleted."
searchRequestManager.delete( sharedFilterID )

    // Now we check if the 'shared filter' has really been deleted.
    if ( searchRequestManager.getSearchRequestById( sharedFilterID ) != null ) {
      logger.error "The filter '${sharedFilter.getName()}' (${sharedFilter.getId()}) owned by '${sharedFilter.getOwner().getDisplayName()}' was not deleted!"
    }

  } else {
    logger.error "The filter with the id ${sharedFilterID} does no more exist!"
  }
}
logger.info "All shared filters (${sharedFilterIDs.size()}) are deleted."

Hope it helps you.

Regards, Rolf

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

housekeeping

jiraserver