As a part of production scenario, I need to extract the access groups which has Developer portal mapped as one of the portals using SQL query. From the clipboard it's visible that the value is present inside pyUserPortals pagelist inside Access Group Page. Tried with the below query however received an error on execution:
SELECT pyAccessGroup, pyPortal,
WHEN PEGP000D01.dbo.pr_read_from_stream('pyUserPortals.pyPortalLayout',"PDA".pzInsKey,"PDA".pzPVStream) ='Developer' THEN 'True'
END AS "Portal Status"
FROM [PEGP000D01].[dbo].[pr_data_admin] as "PDA"
***Edited by Moderator: Pooja Gadige to add capability tag***
@MayankJ2 Thanks for your suggestion. Actually, the problem statement was to get old of all the embedded portals within a particular access group. I have created a Declare Index in Data-Admin-Operator-AccessGroup with Source Page Context Class as Embed-PortalLayout and Source Page Context as .pyUserPortals() with Source Class Property as pyPortalLayout This has resolved the problem and helped me to get hold of all the portals mapped to a particular access group in the Index Class property.