Manage filter with owner's name not working in 7.1.9 version

Question

Hi Team,

User has this issue with the saved filters:
User has hundreds of filters, shared with everyone, but since some weeks, we can see only 2 of them when searching by Owner.
When we actually search in the total list of filters, we find many filters with the Owner name and shared with everyone.

This issue is with many users not with single user.

Please suggest me the possible solution to rectify the problem.

Andy Heinzer · Answer

7.1.9 is one of the last versions of Jira that has the option to share a filter with the entity called 'anyone'.   In 7.2 and later version of Jira do not explicitly use that term.  Instead 7.2 and higher have the option to use the 'Any logged in user' instead.   This is more clear in regards to which users are being shared the filter.

I would recommend reviewing the KB Anonymous users able to see shared filters dashboards or project issues.  This KB explains more details about this scenario.  Because older versions of Jira would let you share filters with anonymous users, it was possible to share these with truly Anyone, which includes anonymous users in this version of Jira.

I understand you have a discrepancy between the SQL and what the Jira UI shows.  I would be concerned with the specific value you have entered there for 'owner'.  That looks like a full or displayname.  Typically I would expect Jira to use a username value instead, such as msagrioti instead of the Lastname, firstname convention.   But if you are sure you have the correct name for the owner field and are still not seeing these, I would still instead recommend using the SQL method as that KB recommends as well.

Prathyusha_bzt0wn · Answer

Hi Andrew,

Thanks for the SQL Query!!

Its working fine for us to filter the Filters shared with everyone and geting the correct output, We have tried to get the saved filters with the owner/User: xxxxx by using the below SQL Query execution and got the result with 152 filters.

But again we we have trying with Manage Filter -> Search Filter -> Owner (xxx)  the filter  as expected. We are trying to find the issue in GUI side.

Please suggest to solution from end user prospective to filter the issues from Manage Filters.( UI )

Currently we are using 7.1.9 Jira version, Let us know if there is any problem with this version of Jira in Managing Filters.

Thanks in Advance.

Andy Heinzer · Answer

Edit: August 21, 2019 - Found out that the searchrequest table is not using the current username of that account, but rather the app_user.user_key field to identify this. It users this because that value is unique and persistent across Jira. As such the old answer could work, but only for accounts that have never been renamed within Jira, this comment below has been updated to reflect a more encompassing set of users (ie both user renames and original user account names). You can just adjust the SQL to look for a specific user's filters that are shared globally: // get list of filters which has share type as "share with everyone" (i.e. global) SELECT sr.filtername, sp.sharetype AS current_share_state, sr.username AS owner_user_key, sr.reqcontent AS JQL
FROM searchrequest sr
INNER JOIN sharepermissions sp ON sp.entityid = sr.id
join app_user au on au.user_key = sr.username
WHERE sp.sharetype='global'
and sp.entitytype ='SearchRequest'
and au.lower_user_name = 'exampleusername'; In that example, you can just replace the exampleusername with the current username in Jira of the account you want to find. This should return all such filters that have been shared globally by that specific account.