Technical Developer Tips and Tricks

 Over the years, I've accumulated some SQL that I use frequently. Here are some ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Find Portal Menu for Component SELECT A.PORTAL_URI_SEG1, A.PORTAL_URI_SEG2, A.PORTAL_URI_SEG3,RTRIM(E.PORTAL_LABEL)|| ' >> '  || RTRIM(D.PORTAL_LABEL) || ' >> ' || RTRIM(C.PORTAL_LABEL) || ' >> ' || RTRIM(B.PORTAL_LABEL) || ' >> ' || RTRIM(A.PORTAL_LABEL) FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE A.PORTAL_URI_SEG2 LIKE '%COMPONENT_NAME%' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Find permission ...

What is a Web Service Simply put a web service is  a method of communication between devices over the World Wide Web (WWW) Characteristics: Uses Request/Response messages over HTTP/S  Hypertext Transfer Protocol The foundation of data communication over WWW Used to send and receive webpages and files on the internet. Messages are text readable such as XML and JSON XML - Extensible Markup Language (rules for encoding documents that are both human and machine readable) JSON – JavaScript Object Notation (file format that uses human readable text)  What is SOAP Simple Object Access Protocol Lightweight protocol for exchanging structured information Use HTTP POST to send XML (Extended Markup Language)\ Provides both Asynchronous and Synchronous  Asynchronous – Doesn’t wait for a response; it is NOT immediate; callbacks happen only when the requested resource is ready Synchronous – Expects an immediate return of data; waits for a response SOAP Example - Web Service from a ...

PeopleSoft has been increasingly adding new ways to modify it's software without intrusive customization. One was is Event Mapping. This allows code to be placed in a application package and change the behavior of pages. These "maps" are tied to components.  Here's a simple example.  1. Create a custom Application Package From Application Designer. Go to File -> New -> Application Package Save it and give it a name Right click on the package and select Insert App Class   Give the class a name Double click to enter PeopleCode Editor Create a class the extends PT_RCF:ServiceInterface An application class for event mapping must import and extend the PT_RCF:ServiceInterface class. In addition, it must define a single method named execute . In this example the class is named make_links_clickable import PT_RCF:*; class make_links_clickable extends PT_RCF:ServiceInterface    method execute(); end-class; Now create the method method execute    /+ Extends...

PeopleSoft Rest Service     Here is a step by step example of how to create a REST service in PeopleSoft.  The first example passes one row of data via the URL. The response includes multiple po lines.  The second example passes JSON in the body with no parameters in the URL. The response is one row per row in the request.   1)     Create template document for inbound parameter(s) (the request). 1)     One or more element names. 2)     Create a view record of the outbound data (the response). 3)     Create template document. 1)     Element names, Collections and Compounds. 2)     Map the document elements to fields in your view 4)     Link messages to document 5)     Create your response message which structures ...