Header Ads

  • Recent Posts

    Finding the Navigation of PeopleSoft Components - Part 4 - Yet Another SQL Query to find navigation of PS Component

    SELECT DISTINCT( portal_objname ),
                   portal_uri_seg2 AS 'COMPONENT'
    FROM   psprsmdefn
    WHERE  portal_uri_seg2 IN (SELECT pnlgrpname
                               FROM   pspnlgroup
                               WHERE  pnlname = '');

    Go to the below navigation and then find the Menu item and Portal Object Name.
    Peopletools > Portal > View Menu Item Details

    Now run the below SQL query and search for the PORTAL_OBJNAME found above.
    Menu path will provide the navigation of the desired Page.

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad