You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

To find out all Components corresponding pages,records,fields in query or is there any way to find out

1 reply [Last post]
Guest's picture
Guest

To find out all Components corresponding pages,records,fields in query or is there any way to find out Please help me out

Guest's picture
Guest (not verified)
Re: To find out all Components corresponding ...

Try something like this ... I can't verify the validity of this SQL as I don't currently have that level of access to a PS DB; but, I believe this is close to what you're looking for ...

Select   PGD.PNLGRPNAME, PGD.DESCR, PG.PNLNAME, PG.ITEMLABEL, PG.FOLDERTABLABEL, PG.PNLNAME, PF.RECNAME, PF.FIELDNAME, PF.LBLTEXT
From     PSPNLGRPDEFN PGD, PSPNLGROUP PG, PSPNLDEFN PD, PSPNLFILED PF
Where    PGD.PNLGRPNAME = 'MYCOMPONENTNAME' And
         PGD.MARKET     = 'GBL'             And
         PGD.PNLGRPNAME = PG.PNLGRPNAME     And
         PGD.MARKET     = PG.MARKET         And
         PG.PNLNAME     = PD.PNLNAME        And
         PD.PNLNAME     = PF.PNLNAME        
Order By PG.SUBITEMNUM, PF.OCCURSLEVEL, PF.FIELDNUM