Identify Filters not shared with anyone

Hi

When i search for filters (as an admin), i only get to see filters which are shared with a project, group or with anyone.

What i do not know is that how many filters are there on my instance which is not shared with anyone.

I want make an update to ALL filters and unless i am able to access all such filters (which are kind of under the water) I wont be able to fix those filters,

Rahul

3 answers

1 accepted

Beside what Peter said, you could look in the table searchrequest. There you can identify the filters which would be affected and notify the owners.

Hi Rahul,

I don't think you can find private filters or change them (even as an admin).

It's the responsibility of the owner to keep them up to date.

You could send out an email or write a confuence page about the change you are going to make and how they can update their filters.

Best regards,

Peter

1 votes

I'm not sure there's any reason to bother. If a filter is private, only the owner can see it, and when they use it, they'll see it's broken and know they have to fix it. Doesn't affect other people.

If you do have some reason to do this, then you'll need to go via the database.

Thanks Nic, yes we have a good reason. We recently changed the priority names, and after that all filters broke. Worse, the filter owners are thinking there are no P0 issues this week and not actioning (which is due to broken filter) rather than the actual status. So, they dont know something has actually broken.

Are you aware of any DB queries (which tables etc) which i can toggle a bit and re-use for this purpose.?

Rahul

use

select * from searchrequest where reqcontent like '%<YourOldStatus>%';

If the filter owners are actually using the filters, you'll find they get an error, not a zero result...

Udo beat me to the SQL

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,009 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot