Jira filters shared with missing groups

This insight checks if any of your JQL filters are shared with groups that no longer exist.

What's the problem?

JQL filters shared with missing groups won't block your migration, but might result in data loss or missing entities in Jira Cloud. To avoid these issues and keep your instance clean, we recommend that you fix those filters before you migrate.

What’s the recommendation?

To avoid issues with missing entities in Jira Cloud:

• Review affected filters
• Remove missing groups from their permissions

Update filter permissions RECOMMENDATION

Follow these steps to remove missing groups from filter permissions.

Review affected filters

When viewing this insight from Portfolio insights, copy the SQL query (also pasted below). The query returns filters shared with missing groups, together with:

• Filter's name
• Missing group's name

SELECT sr.filtername AS filter_name,
sp.entitytype AS bla,
sp.param1 AS group_name
FROM searchrequest sr
JOIN sharepermissions sp ON (sr.id = sp.entityid)
WHERE sp.entitytype = 'SearchRequest'
AND sp.sharetype = 'group'
AND NOT EXISTS (SELECT id FROM cwd_group g WHERE g.group_name = sp.param1);

Fix 1: Recreate missing groups

You can use the list of missing groups from the query above to recreate them in Jira. This can save you time editing the filter and removing permissions.

Fix 2: Update filter permissions in Jira UI

To update the filter's permissions:

1. In Jira, go to Administration > Filters.
2. Search for the affected filter returned by the SQL query.
3. Select the filter to open it. 
4. Select Details at the top, and then select Edit permissions.
5. Remove the missing groups from the permissions.