How to get a list of filters and dashboards shared with a specific group in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
In Jira, you may want to get a list of all dashboards and filters that are shared with a specific group. This is possible by using SQL queries below (they were written for PostgreSQL, so some modification for your DBMS may be required)
Solution
How to get a list of filters shared with a specific group. Replace group-name with the desired group.
1
2
3
4
SELECT sr.id, sr.filtername
FROM searchrequest sr
INNER JOIN sharepermissions sp on sr.id = sp.entityid
WHERE sp.entitytype = 'SearchRequest' AND sp.sharetype = 'group' AND (param1 = 'group-name' OR param2 = 'group-name')How to get a list of dashboards shared with a specific group. Replace group-name with the desired group.
1
2
3
4
SELECT pp.id, pp.pagename
FROM portalpage pp
INNER JOIN sharepermissions sp on pp.id = sp.entityid
WHERE sp.entitytype = 'PortalPage' AND sp.sharetype = 'group' AND (param1 = 'grup-name' OR param2 = 'group-name')Was this helpful?