User Tools

Site Tools


tech:psoft:psprsmdefn_query

Content Reference Heirarchical Query

PIA navigation to any given component:

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 = :1
connect by prior
         portal_prntobjname = portal_objname
tech/psoft/psprsmdefn_query.txt · Last modified: 2024/02/21 19:09 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki