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 vote

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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

236 views 1 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