An SQL that goes against a specific component and bring back ALL related records.
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 |
Comments
This SQL is very useful.
I want to get the list of all components ,corresponding records,pages,fields, People Code Events in a query or else is there any way to find it out
u can use this query to get the above result
select * from PSPROJECTITEM where projectname='project name';
PSPROJECTITEM record will capture the objects present in the project only.
If you want to get the list of components, pages, rec, fields then you need to refer differernt tables. I am listing that below
SELECT * FROM PSPNLGROUP ; /* All the Components */
SELECT * FROM PSRECDEFN; /*All the records and views*/
SELECT * FROM PSPNLFIELD WHERE PNLNAME = 'H_HR_CHNG_ASGMNT'; /* Covers record and field associated in a page */
Thanks.
Hari.A