Structure of a Component
The following queries give you the structure of a component.
This query gives you the pages, occurs level, record and field name for a given component:
select distinct
C.PNLGRPNAME,
P.PNLNAME,
P.OCCURSLEVEL,
R.RECTYPE,
R.RECNAME,
P.FIELDNAME
from
PSPNLGROUP C inner join PSPNLFIELD P
on C.PNLNAME = P.PNLNAME
inner join PSRECDEFN R
on R.RECNAME = P.RECNAME
where
C.PNLGRPNAME = 'YOUR_COMPONENT_NAME'
order by P.OCCURSLEVEL, R.RECNAME asc;
This query gives a summary of the records, what occurs level they are on, and what type of record they are (record type):
select distinct
P.OCCURSLEVEL,
R.RECTYPE,
R.RECNAME,
R.RECDESCR
from
PSPNLGROUP C inner join PSPNLFIELD P
on C.PNLNAME = P.PNLNAME
inner join PSRECDEFN R
on R.RECNAME = P.RECNAME
where
C.PNLGRPNAME = 'YOUR_COMPONENT_NAME'
order by P.OCCURSLEVEL, R.RECNAME asc;
No Comments