Display Pages Associated to a Component

Your rating: None Average: 1 (1 vote)

For example, if you have a component that has 3 pages on it, then when you run this SQL, lets say in your test environment, you should have 3 rows back.

SELECT page.* FROM PSPNLDEFN PAGE, PSPNLGROUP COMP
WHERE COMP.PNLGRPNAME = :component_name
AND PAGE.PNLNAME = COMP.PNLNAME;

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!