Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to add 3000+ groups in below SQL to find the list.

kalyan balla May 16, 2025

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');

0 answers

Suggest an answer

Log in or Sign up to answer