Fetch Embedded Properties values using SQL statement
Hello,
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"
Deutsche Bank Operations International (DBOI)
IN
@AvikG - Have you tried below?
select PYRULENAME, PZINSKEY from <rule schema>.pr_index_reference where PXRULEOBJCLASS = 'Rule-Portal'
Capgemini
SE
@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.