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.

Finding Page in PIA if you know the page name

6 replies [Last post]
Guest's picture
Guest

How can we find page in PIA if we know the page name (thru application Designer)

Lepa's picture
User offline. Last seen 3 days 14 hours ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Finding Page in PIA if you know the page name

If you know the page name then you can find the component the page is sitting on. After you have the component name, you can then find the path in PIA for that page.

So, get the component name by running the following SQL:

SELECT page.pnlname, comp.pnlgrpname
  FROM pspnldefn page, pspnlgroup comp
 WHERE page.pnlname = :PageName AND page.pnlname = comp.pnlname;

Then follow the instruction on the following blog post to get the PIA path to your component/page. http://www.compshack.com/peoplesoft/queries/query-component-path-within-...

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

premkumars57's picture
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 11/17/2008
Posts: 3
How to find components and its related records with key values

Hi,
Could any one tell me the easiest way to find the components and its related records with Key values(fields) in PIA.
Right now am using CTRL+J for each navigation in PIA page to find the component then using app.designer to find the records and its key fields.
Did any one have any doc that should contain all the components and records which belongs to "Set UP HRMS"

Thanks.

Lepa's picture
User offline. Last seen 3 days 14 hours ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Finding Page in PIA if you know the page name

Here is a post made some time back that will give you records behind a component. http://www.compshack.com/peoplesoft/get-records-component
It doesn't give you key fields though. I got you half the way there, now its your turn ;)

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

Ashar's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Finding Page in PIA if you know the page name

Almost everything you require is already here in this site. :-)
You only have to modify the SQL as required

shiv4uall's picture
User offline. Last seen 8 years 30 weeks ago. Offline
Joined: 11/18/2008
Posts: 8
Re: Finding Page in PIA if you know the page name

Once you know the component name, you can also find it in a simpler way.
On Search Text Box in the Peoplesoft Home page, Type in the component name. It will get back to you with the actual navigation to that Component/Page.

premkumars57's picture
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 11/17/2008
Posts: 3
Define BenAdmin

Hi,
Could any one define what is BenAdmin?, and how it is working, like abt the process of the benadmin? and explain abt the run schedule only employee and process only participants and benefit program participant in benefits process. Please reply in breif or short note abt benefits. I'm waiting for the reply

Thanks,

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
7 + 11 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.