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

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"

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

 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.