Who Modified this PeopleCode?

Your rating: None Average: 4 (4 votes)

Nothing frustrates me more than developers modifying delivered PeopleSoft code without adding comments. It is easy to figure out who was the last person to touch a record by clicking on the Record Properties button in application designer. BUT it is not that easy when it comes to PeopleCode.

I have written the following SQL to help me identify the last person to modify a Record Field PeopleCode Event.

SELECT objectvalue1 record_name, objectvalue2 field_name,
       objectvalue3 peoplecode_event, lastupddttm, lastupdoprid
  FROM pspcmprog
 WHERE objectvalue1 = :record_name
   AND objectvalue2 = :field_name
   AND UPPER (objectvalue3) = UPPER (:peoplecode_event);

The SQL could be easily modified to work on any PeopleCode event level (component, page, or Record level). My need was to write it against Record Field PeopleCode.

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Kevin's picture
Kevin (not verified)
Re: Who Modified this PeopleCode?

Hi, Lepa
Is it working on PS 7.63.04?
I found that there are only these fields in the record: PROGNAME, PROGSEQ, VERSION, NAMECOUNT, PROGLEN, PROGRUNLOC, LASTUPDDTTM, LASTUPDOPRID, PROGTXT.
Which one is record name? And field name?
I will appreciate that if you could reply with email.
Thanks a lot!

Mukund's picture
Mukund (not verified)
Re: Who Modified this PeopleCode?

Hi Lepa, great piece of work!