PeopleCode 2 Write Query to get the Page PeopleCode Events i

PeopleCode

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

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;