Hi All,
We are trying to fetch the groups association dashboards and projects using following sql, but we are unable to fetch 3000+ groups at a time showing "Enter Value for ISE" prompt
Can some one help on this.
SELECT
shp.param1 AS "Group",
pp.pagename AS "Dashboard"
FROM
sharepermissions shp
LEFT JOIN portalpage pp ON shp.entityid = pp.id
WHERE
shp.entitytype = 'PortalPage'
AND shp.sharetype = 'group'
AND shp.param1 IN ('jira_xhd', 'SR_Other');