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.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 16 weeks ago
2 years 21 weeks ago
2 years 21 weeks ago
2 years 23 weeks ago
2 years 23 weeks ago
2 years 23 weeks ago
2 years 26 weeks ago
2 years 27 weeks ago
2 years 30 weeks ago
2 years 36 weeks ago