How can I find broken filter?

If I delete or rename project keys, project names, fields, status, components, issuetypes etc. and a filter is using some of that, the filter will broke. Currently I avoid that if possible.

I would like to clean up our JIRA soon. But I do not want to annoy my colleagues with faulty filters.

Does anyone know how I can do the following?

- Get all JQL-Filters (in Text) including the Owner. I would then look for filters that would no longer work after a change. Then I could correct the filters manually. For this, I would assume the identity of the user (User Switcher plugin).

- Alternatively, I would need a list of all filters that no longer work.

Is there a plugin for these requirements? Or this works only with SQL? How would such a query look like? Or how you solve those problems?

1 answer

This widget could not be displayed.
Andy Nguyen Atlassian Team Dec 29, 2014

Hi Max,

This seems to be an old question but I just want to add on my opinion in case it might still be useful.

  • As for your second point, I'm afraid that there's no way to detect filters which no longer work in JIRA. I'm not aware of any plugins which can do so and personally think it can only be achieved with SQL.
  • For your first point, or the SQL query, you can look into table searchrequest in JIRA database. You can just select all to get everything but the most important fields should be id, filtername, authorname, and reqcontent. So you may want to use this:

    SELECT id, filtername, authorname, reqcontent FROM searchrequest;

Please take note that you may not be able to access all the filters if you're not a JIRA admin or if they are private. Some more SQL tricks will be needed to achieve that.

Cheers,
Andy

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 12 hours ago in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

39 views 1 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you