Filters cleanup

[Anuradha]

Hi Team,

In our Jira we have, 422500 filters, some of which are owned by disabled users. We want to cleanup.

we have below data with us:

Filter Owner

Filter Owner Active

Filter Name

Filter ID

Private or Shared

View Permissions

Edit Permissions

Favorite Count

Used in Boards

Used in Dashboards

Any idea/best practice to check on cleanup?

like eg: for Inactive User, private we have 4786 to delete

for- inactive,private,favourite count-0 we have 708 filters to delete..

Any such ideas which can speed up our cleanup activity please help.

Regards,

Anu

[Mark Segall · Accepted solution]

Hi @Anuradha and welcome to the community!

Wow - With that many, you may want to buy a script-savvy colleague a few cups of coffee to manage this through the API.  Here's the documentation on managing filters through the API:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-filters/

[Hubert Kut · Accepted solution]

Hi @Anuradha 

Our app can review all public and private filters in your instance and much more.

Doctor Pro: Audit, Optimize & Manage Configuration for Jira
https://marketplace.atlassian.com/apps/1231705/doctor-pro-audit-optimize-manage-configuration-for-jira?hosting=cloud&tab=overview

If you have any questions feel free to reach out to us!
Best
Hubert

[Anzar · Accepted solution]

Please accept answer on this comment if my answer above solves your problem.

It will just add a boost to my profile😊.

Regards,

Anzar Khan

[Anuradha · Accepted solution]

Is there any way to delete bulk filters using script runner?

[Anzar]

Hello Anuradha,

The ability to bulk delete filters was considered as a possible enhancement in Jira before, however, the developers might have decided to not implement it due to the low number of requests:

https://jira.atlassian.com/browse/JRASERVER-68433

that being said, there is a possible workaround to this issue:

1. Identify your filter ids by using the REST API Search for filters

2. Once you have the filter ids, bulk deletes them by creating a script with the REST API to delete filters:
   DELETE /rest/api/3/filter/{id}

Let us know if you have any questions.

Regards,

Anzar Khan

[Anuradha]

Hi Anzar, 

Thanks for your answer,

but first we need to find out who are the users who have favorited the filters,

Can I have some script or idea to fetch the favorited users?

because we have 3.5k filters created by users who are not active but these filters are favorited by single users and we want to find out who?

Please help..

Regards,

Anuradha

[Anuradha]

adding to it.. these 3.5k filters are private.

[Dasari Sravanthi]

In this case you can usee power admin app to get the private filters owned by inactive users. Let me know if that helps