Archive for February, 2012


Helpful SQL to search peoplecode

PeopleSoft finally in 8.52 tools delivers a table with all peoplecode listed in plain text in table: “pspcmtxt”.

Use this SQL:

select objectvalue1,objectvalue2,objectvalue3,objectvalue4,pctext from pspcmtxt ;

Example:

select objectvalue1,objectvalue2,objectvalue3,objectvalue4,pctext from pspcmtxt where UPPER(pctext) like ‘%CLEARDROPDOWN%’

Use the ViewContentURL function to launch a new browser window and navigates to the location specified by URL_str or URL.URL_ID. The content specified by the URL is not wrapped by the portal template. Use this function when you want to connect to third-party content.If you want to wrap the content in the portal template, use the ViewURL function. This function automatically launches a new browser window.

Example

If &MyPage Then

ViewURL(URL.MYPAGE);

Else

ViewContentURL(http://www.google.com);

End-If;