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

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

Solution

2.

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;