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 ...