Is there any way to remove all filters shared with "Everyone"?

[Ben Radlinski]

Our JIRA deployment's shared filters are getting out of control due to the default "Share with Everyone" designation when they're created. I have read the posts about removing the Share with Everyone option from the drop-down, but I was hoping there's a way to change the current filters to NOT be shared with everyone?

Any help would be appreciated.

[Danyal Iqbal · Accepted solution]

nope. ntot without tinkering with the db :)

This sql is a good starting point to list all filters with share type as "share with everyone"

SELECT sr.filtername, sp.sharetype AS current_share_state, sr.username AS owner_name, sr.reqcontent AS JQL
FROM searchrequest sr
INNER JOIN sharepermissions sp ON sp.entityid = sr.id 
WHERE sp.sharetype='global' and sp.entitytype ='SearchRequest';

 Tips:

• Don't maek changes in the db directly. It will break something 9 out of 10 times:)
• create a db backup if you really want to make changes.

[Ben Radlinski]

Thanks. I figured this was probably the only way, but I thought I'd ask. Thanks for your help.