PeopleSoft Integration Broker related articles, setups, tips and tricks.
I had the need to count an occurrence of a specific character in a string and after tossing some ideas back and forth between a couple of my colleges, we came up with the below two SQLs. You pass a string and identify the character you are looking to count its occurrence. In both SQLs below, I'm trying to count how many times does ">>" exists in string "This is>>a string>>to look into>>". The answer of course is 3 times.
SQL Option 1:
A straight forward SQL to get edit tables behind field(s) for a specific record. The SQL execludes any edit tables that start with "%" as those are dynamic edit tables with values populated by PeopleCode at run time and thus will not be of a good use in this query.
SELECT R.FIELDNAME , R.EDITTABLE FROM PSRECFIELDDB R , PSDBFIELD F WHERE R.RECNAME = :RecordName AND SUBSTR(R.EDITTABLE,1,1) <> '%' AND R.EDITTABLE <> ' ' AND R.FIELDNAME = F.FIELDNAME AND F.FLDNOTUSED = 0;
A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page. Example, Add Update/Display and so forth.
A query that takes a PeopleSoft role name as a value and returns Permission List(s) associated to that role.
A section to collect and organize PeopleSoft Role related queries.
Another permission list query to list Content References accessed by a specific Permission List.
A query that will list all peopletools objects (Query, Application Designer, Data Mover) that a specific permission list could access.
A query to identify pages that could be accessed by a specific permission list.
A query to help you identify Roles that are assigned to a specific permission list.
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|