Peoplecode 1 Write Query to get the Record PeopleCode Event

###

Peoplecode

1. Write Query to get the Record PeopleCode Events in a give component.

2. Write Query to get the Page PeopleCode Events in a give Component

3. Write Query to get the Component, Component Record and Component Record Field PeopleCode Events

Solution

2. Query to get the Page PeopleCode Events in a give component.

SELECT DISTINCT
C.OBJECTVALUE1,
C.OBJECTVALUE2
FROM PSPNLFIELD B, PSPNLGROUP A, PSPCMPROG C
WHERE A.PNLNAME = B.PNLNAME
AND A.PNLGRPNAME = \'<TYPE COMPONENT NAME HERE>\'
AND B.FIELDUSE NOT IN (8209,21,17,19,8211,9243)
AND B.RECNAME <> \' \'
AND B.FIELDNAME <> \' \'
AND C.OBJECTID1 = 9
AND C.OBJECTVALUE1 = B.PNLNAME;