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.

PeopleSoft - Need SQL to reference subpages that exist on a page

1 reply [Last post]
wannamartini's picture
User offline. Last seen 11 years 36 weeks ago. Offline
Joined: 04/16/2009
Posts: 1

Can someone tell me what sql to run to find the subpages assigned to a page? I am looking at the fields used on a group of pages, but some of the pages contain subpages. So I'm missing the fields for those. I was able to pull the fields from pages. Now I need to identify the names of the subpages included in some of the pages.

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: PeopleSoft - Need SQL to reference subpages that exist ...

This SQL will return all records on a page (including records used on a subpage). Once you have all the records you can then join to the record table and get all the fields!

The SQL above gets you half way there :)

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog