Remove orphan filters

[Luca Andreatta]

Hi all,

I created an Agile Project, deleted it and recreated with the same name after some experiments.

Now I'm in the situation that I cannot change the ownership of the filter because the user has already the old one assigned to him, although he cannot see it.

Looking at searchrequest table I see that there are two filters with the same name, but the old one doesn't have any associations to sharepermissions table.

How can I clean all these orphan filters? I am in jira-administrator group, but I cannot see them.

[Earl McCutcheon · Accepted solution]

Hey Luca,

You would normally need to change the owner as described in the doc:

• Managing shared filter

Noting The filter must be shared with the admin for the admin to be able to make the edit on the filter, and "A shared filter can only be edited by the shared filter's owner." So you would need the owner to  share the filter with you to be able to make the modification to the ownership.

However, as you noted the user cannot see the filter to share it, so you could do a database modification on the "author" column of the searchrequest table to update this to your username and then make any additional modifications to ownership and shares or removal of unused filters as needed.

Make sure to take jira offline, and back up the db before making any modifications, then after updating the table and restarting trigger a re-index to update the filter results in the index, and you should be all set

Regards,
Earl

[Luca Andreatta]

Hi Earl,

I was wrong, I assumed that admin users could manage all filters, shared or not.

But, as you pointed me out, I saw that if you don't share them, admins could not find them in the Shared filters in the System administration page.

In our case, we, admins, create agile projects for other people and configure dashboards and filters for them assigning ownership to them. But when the project is deleted we need to delete filters and dashboards as well and, as far as I understand, we should ask these people to delete filters and dashboards.

It should be nice if we could manage these filters as administrator without asking them anything.

Maybe this way of using JIRA is not so common...

[Earl McCutcheon]

Hi Luca, 

While it still does not expand the option for an admin to take ownership of a filter unless it has been shared with them, One thing to look into that expands the usability of the filter management is a new Group Editor permission on the filters that we  released with 7.12, additional details on this can be seen in the release notes and the feature request here:

• https://jira.atlassian.com/browse/JRASERVER-17783
• 7.12 Release Notes

Another popular option to manage other users filters when your locked out on a share permission is to use the free User Switcher for Jira add-on to temporarily promote an admin account to the filter owners account to share the filter so that you can make the ownership changes once switched back to the admin.

Regards,
Earl

[Luca Andreatta]

Thank you very much Earl, I installed User Switcher plugin and now I have full power over the realm again! :-)

A bit too much for what I needed, but it's fine indeed.