Header Ads

  • Recent Posts

    Finding the Navigation of PeopleSoft Components - Part 2 - SQL Query to find navigation of PS Component

    Earlier, in one of my posts I had two different SQL queries to find the online navigation of a PeopleSoft component. Sometime back, I came across another SQL from PeopleSoft  tipster which the author claims to be the most succinct version and rightly so. This SQL is short and comes in handy several times to find the Portal navigation.

    Here is the SQL:
    SELECT DISTINCT RTRIM(REVERSE
                           (SYS_CONNECT_BY_PATH(REVERSE

                             (PORTAL_LABEL), ' > ')), ' > ') PATH
    FROM PSPRSMDEFN
    WHERE PORTAL_NAME = 'EMPLOYEE'
          AND PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'
    START WITH 
          PORTAL_URI_SEG2 = ‘NAME_OF_THE_COMPONENT’
    CONNECT BY PRIOR
          PORTAL_PRNTOBJNAME = PORTAL_OBJNAME;

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad