Working with the Portal Menu Structure via the database

I was trying to find all the object that were under a folder in the PIA portal via the data base. The problem is that the menu / component structure is not the PIA portal stucture and the object names in the portal are laid out differently. The portal stucture is laid out in the PSPRSMDEFN table. This table has a whole slew of infomation in it and is used to build the URLs for the portal to point to the menu / componet layer; the PORTAL_URI_SEG# fields are the different parts of the URL that the PIA layer uses to access the components.

Select * FROM SYSADM.PSPRSMDEFN where PORTAL_PRNTOBJNAME = ‘MY_PARENT_OBJECT’;

This gives all the objects directly below 'MY_PARENT_OBJECT'. The object type is stipulated by a C' for component or 'F' for folders; there are another couple of types for links etc... In order to find all the objects below another you would need a resursive function that drills down each level because for each object, you only have its parent.

Find All Components that have a Page

When looking to see what effect a change on a page might have, it is good to know where the page is used in the application. Here is an SQL to find all the places that the page 'SCC_BIO_DEMO_PERS' is used in the application.

SELECT

PNLGRPNAME, MARKET, PNLNAME,

SUBITEMNUM, ITEMNAME, ITEMLABEL,

FOLDERTABLABEL, HIDDEN

FROM SYSADM.PSPNLGROUP where pnlname = 'SCC_BIO_DEMO_PERS'

Andrew March 10

Kate and Andrew March 7th Posting

Assorted Pictures.

Front to Back