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.

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

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