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

[Fabio Racobaldo _Catworkx_]

Hi @kalyan balla ,

SQL query seems ok. Please check your db connection because it seems that message is related to connection and not to query itself. What is DBMS? What's your db client?

Fabio