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

How to cleanup unused filters in Jira

Erik Mathijs

I want to cleanup filters from inactive users, but only those filters wich are not used in any rapid board(s)

Is it possible to get a list from this filters within Jira or via a sql query ?

Accepted answers

Suvarna Gaikwad_3o435r

@Erik Mathijs you can try this SQL to get filters of inactive users and not being used on boards.

select * from searchrequest where id not in (select saved_filter_id from AO_60DB71_RAPIDVIEW) and username in (select user_name from cwd_user where active = 0)

All comments

John Funk

Hi Erik,

Using the API is probably the best route. See if this helps you:

https://community.developer.atlassian.com/t/how-to-get-all-filter/26526

Suvarna Gaikwad_3o435r

@Erik Mathijs you can try this SQL to get filters of inactive users and not being used on boards.

select * from searchrequest where id not in (select saved_filter_id from AO_60DB71_RAPIDVIEW) and username in (select user_name from cwd_user where active = 0)