Finding broken filters in Cloud without API Calls

[Rebekka Heilmann _viadee_]

For most of us, long gone are the times where we could repair JQL filters via the database. With our recent move to Cloud we are now facing the challenge of 

1. finding broken filters automatically 

2. repairing them in Bulk

Luckily we've foreseen this and updated statuses, custom fields and such still on Data Center. With the recent changes to Epic Link / Parent fields though, I know for a fact that some of our filters are broken because they've not been updated automatically. Parent field has been populated automatically but filters still refer to Epic Link.

What defines a broken filter you might ask? -> If you open it in the UI and you get an Error message in red and no results.

---

There have been some interesting suggestions finding broken filters via API Calls in this thread: Solved: How Can I find all the broken filters and their ow... (atlassian.com)

However, I am looking for a solution which requires less hacking & more UI. 

Does anyone know of a Marketplace App or another solution to find broken filters?

[Kian Stack Mumo Systems · Accepted solution]

@Rebekka Heilmann _viadee_ , use this! https://marketplace.atlassian.com/apps/1229737/cleanup-manager-for-jira?hosting=cloud&tab=support

It works very nicely for me!

[Rebekka Heilmann _viadee_]

Sorry for the late answer!

The App itself looks great. However for filters they only have one health check: 

Update: In the Filter Overview all Columns can be filtered. Therefore you can do a contains-search on the JQL Query and it should do the trick :) 
Won't update the filters like a DB statement would but I can at least find the broken ones!