Get Access Policy Child Data Query:
select
POL.POL_NAME as Access_Policy_Name,
UGP.UGP_NAME as Role_Name,
OBJ.OBJ_NAME AS Resource_Name,
--SDK.SDK_NAME AS Child_Table_Name,
SDK.SDK_FORM_DESCRIPTION AS Child_Table_Description,
--POC.POC_FIELD_NAME AS Child_Table_Field_Name,
SDC.SDC_LABEL AS Child_Table_Field_Label,
POC.POC_FIELD_VALUE AS Child_Table_Field_Value
from POC, POL, SDK, OBJ, POG, UGP, SDC
where POC.POL_KEY=POL.POL_KEY and POC.SDK_KEY=SDK.SDK_KEY and POC.OBJ_KEY=OBJ.OBJ_KEY
and POG.POL_KEY=POL.POL_KEY and POG.UGP_KEY=UGP.UGP_KEY and
SDC.SDC_VERSION=SDK.SDK_ACTIVE_VERSION and POC.POC_FIELD_NAME=SDC.SDC_NAME
select
POL.POL_NAME as Access_Policy_Name,
UGP.UGP_NAME as Role_Name,
OBJ.OBJ_NAME AS Resource_Name,
--SDK.SDK_NAME AS Child_Table_Name,
SDK.SDK_FORM_DESCRIPTION AS Child_Table_Description,
--POC.POC_FIELD_NAME AS Child_Table_Field_Name,
SDC.SDC_LABEL AS Child_Table_Field_Label,
POC.POC_FIELD_VALUE AS Child_Table_Field_Value
from POC, POL, SDK, OBJ, POG, UGP, SDC
where POC.POL_KEY=POL.POL_KEY and POC.SDK_KEY=SDK.SDK_KEY and POC.OBJ_KEY=OBJ.OBJ_KEY
and POG.POL_KEY=POL.POL_KEY and POG.UGP_KEY=UGP.UGP_KEY and
SDC.SDC_VERSION=SDK.SDK_ACTIVE_VERSION and POC.POC_FIELD_NAME=SDC.SDC_NAME
No comments:
Post a Comment