Portal Archive

Creating PeopleSoft Portal Homepage – Part II – Using Queries

One of the things we have added to the portal was ePro approvals pagelet. This pagelet allows ePro users to see and action the items that they need to approve, as soon as they

Creating PeopleSoft Portal Homepage

Several months ago we had undergone Peoplesoft upgrade to 9.1. As I was going through the new features available in Tools 8.51 and applications, I realized that we should be putting a lot more

SQL for Retrieving Portal, Security, Record and Navigation

SELECT DISTINCT ltrim (rtrim (a.classid)) AS classid, ltrim (rtrim (b.menuname)) AS menuname, ltrim (rtrim (b.barname)) AS barname, ltrim (rtrim (b.baritemname)) AS baritemname, ltrim(rtrim(d.pnlname)) AS pnlname, ltrim (rtrim (d.itemlabel)) AS itemlabel, ltrim (rtrim (e.itemlabel)) AS