PeopleCode 1 Write Query to get the Record PeopleCode Events

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

1)

SELECT DISTINCT

B.PNLNAME,

B.RECNAME,

B.FIELDNAME,

C.OBJECTVALUE3,

B.FIELDUSE

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,22)

AND B.RECNAME <> \' \'

AND B.FIELDNAME <> \' \'

AND C.OBJECTID1 = 1

AND C.OBJECTVALUE1 = B.RECNAME

AND C.OBJECTID2 = 2

AND C.OBJECTVALUE2 = B.FIELDNAME

ORDER BY B.RECNAME,B.FIELDNAME;