Find Navigation of Page from Component Name in PeopleSoft Portal-优快云博客

本文介绍了一个利用SQL查询从PeopleSoft Portal中找到指定组件名对应页面导航路径的方法，通过执行特定的SQL语句，可以轻松获取所需页面的完整导航结构。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Many times we came across situation where we have Page name but we dont know the navigation for this page in Portal.

Following SQL makes the job easy for us.
Execute the following SQL in Database.

   SELECT 
   REPLACE
   (navigation
   ,
   ''
   ,
   ' > '
   ) 
   "PIA Navigation"
   

   , url
   

   , MENU_NAME
   

   , COMPONENT_NAME
   

   , portal_objname
   

   , portal_prntobjname
   

   , portal_uri_seg3
   

   ,portal_label
   

   FROM 
   (
   SELECT SYS_CONNECT_BY_PATH 
   (a
   .portal_label
   ,
   '>>'
   ) navigation
   

   , 
   '/EMPLOYEE/ERP/c/' 
   || a
   .portal_uri_seg1 
   || 
   '.' 
   || a
   .portal_uri_seg2 
   || 
   '.' 
   || a
   .portal_uri_seg3 url
   

   ,  a
   .portal_uri_seg1  MENU_NAME
   

   , a
   .portal_uri_seg2  COMPONENT_NAME
   

   , a
   .portal_objname   portal_objname
   

   , a
   .portal_prntobjname  portal_prntobjname
   

   , a
   .portal_uri_seg3 portal_uri_seg3
   

   , a
   .portal_reftype portal_reftype
   

   ,a
   .portal_label portal_label
   

   FROM 
   (
   SELECT 
   DISTINCT a
   .portal_name
   

   , a
   .portal_label
   

   , a
   .portal_objname
   

   , a
   .portal_prntobjname
   

   , a
   .portal_uri_seg1
   

   , a
   .portal_uri_seg2
   

   , a
   .portal_uri_seg3
   

   , a
   .portal_reftype
   

   FROM psprsmdefn a
   

   WHERE portal_name 
   = 
   'EMPLOYEE'
   

   AND portal_objname 
   <> portal_prntobjname
   

   AND 
   NOT 
   EXISTS 
   (
   SELECT 
   'X'
   

   FROM psprsmsysattrvl
   

   WHERE portal_name 
   = a
   .portal_name
   

   AND portal_reftype 
   = a
   .portal_reftype
   

   AND portal_objname 
   = a
   .portal_objname
   

   AND portal_attr_nam 
   = 
   'PORTAL_HIDE_FROM_NAV'
   

   AND a
   .portal_objname 
   NOT 
   IN 
   (
   'CO_NAVIGATION_COLLECTIONS'
   ,
   'PORTAL_BASE_DATA'
   )
   )
   ) a
   

   WHERE portal_uri_seg2 
   LIKE 
   '%COMP_NAME%'
   
START 
   WITH a
   .portal_prntobjname 
   = 
   'PORTAL_ROOT_OBJECT'
   
CONNECT 
   BY PRIOR a
   .portal_objname 
   = a
   .portal_prntobjname
   )
   

   WHERE navigation 
   NOT 
   LIKE 
   '%Navigation Collections%'
  