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

[kalyan balla]

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