This is another quick SQL snippet that I find useful. When would you use it?
Well, you forgot a certain record name, but you know that the record has EMPLID, NAME, EMPL_REC fields on it.
You can query the database to find out what records have the fields you are looking for.
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
Here is a similar sql but I use it for different puporse. I use this to find out the record mappings of a field while designing the application.
To find the list of records that has specific field in that record. Useful in finding out mappings.
SELECT A.RECNAME, A.FIELDNAME, B.DESCRLONG AS RECORDDESCRIPTION
FROM PSRECFIELD A, PSRECDEFN B
WHERE A.FIELDNAME IN( 'FIELD_NAME' ,'FIELD_NAME' , 'FIELD_NAME' )
AND A.RECNAME = B.RECNAME
AND A.RECNAME NOT LIKE '%WRK%'
AND A.RECNAME LIKE 'TL%'
AND A.RECNAME NOT LIKE '%TAO'
AND A.RECNAME NOT LIKE '%TMP'
AND A.RECNAME NOT LIKE '%SRCH'
AND A.RECNAME NOT LIKE '%SBR'