What a filter is associated with?

[Karie Kelly]

We would like to clean up our library of filters, removing those that are no longer being used.

However, if we delete a filter that is associated with the board, the board is actually removed automatically. And, if a filter is used in someones gadgets/jira issues macro, we don't want to remove it and cause it to break.

But, given that we have hundreds of pages, it's impossible to go through the UI to determine where they are used.

Does anyone have a good process for determining whether or not a filter is being referenced somewhere?

It would be really nice if there were an administrative function that we could use to see such references to assist with cleanup.

[David Chan · Accepted solution]

As mentioned by Pedro, there's no easy to do this via the UI. You can however go into the database. For example, if you're using PostgreSQL:

select * from "AO_60DB71_RAPIDVIEW" a join searchrequest s on a."SAVED_FILTER_ID"=s.id;

[Karie Kelly]

Thanks for this example. We are trying to narrow down our saved filters to not only improve users searches for a specific filter, but when someone terminates, we want to either change ownership or get it deleted to keep the db as clean as we can.

[Pedro Cora]

Currently this is not possible. There's an improvement request for this at JRA-28728