Fetch Embedded Properties values using SQL statement
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, CASE
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"