Get Records on a Component

Your rating: None Average: 4.7 (6 votes)

An SQL that goes against a specific component and bring back ALL related records.

SELECT   recname
    FROM pspnlgroup a, pspnlfield b
   WHERE (a.pnlname = b.pnlname OR a.pnlname = b.subpnlname)
     AND a.pnlgrpname = :component_name
GROUP BY recname

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Guest's picture
Guest (not verified)
Re: Get Records on a Component

This SQL is very useful.

Guest's picture
Guest (not verified)
Hi All,

I want to get the list of all components ,corresponding records,pages,fields, People Code Events in a query or else is there any way to find it out

vivek6686's picture
User offline. Last seen 8 years 5 weeks ago. Offline
Joined: 09/27/2010
Posts: 8
Re: Hi All,

u can use this query to get the above result
select * from PSPROJECTITEM where projectname='project name';

Hari_aindian's picture
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: Get Records on a Component

PSPROJECTITEM record will capture the objects present in the project only.

If you want to get the list of components, pages, rec, fields then you need to refer differernt tables. I am listing that below

SELECT * FROM PSPNLGROUP ; /* All the Components */

SELECT * FROM PSRECDEFN; /*All the records and views*/

SELECT * FROM PSPNLFIELD WHERE PNLNAME = 'H_HR_CHNG_ASGMNT'; /* Covers record and field associated in a page */

Thanks.
Hari.A