Display Pages Associated to a Component

Thu, 01/24/2008 - 12:13am — Lepa

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;

Bookmark/Search this post with

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.

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>. The supported tag styles are: <foo>, [foo].

BBcode

You can use BBCode tags in the text.
Lines and paragraphs break automatically.
Web page addresses and e-mail addresses turn into links automatically.

More information about formatting options

Notify me when new comments are posted

CAPTCHA

The question below is to prevent automated spam submissions.

What code is in the image?: *

Enter the characters shown in the image.

Unanswered Forum Posts

Title	Under	Posted on
MD5 - SHA checksum of a file.	PeopleSoft Technical	02/07/2012 - 5:29am
nVision Tabular Report through PIA with prompts	PeopleSoft Technical	02/02/2012 - 10:07pm
Can we create an AE to mass update Position - Jobcode data?	PeopleSoft Technical	01/18/2012 - 3:11am
Pay Components on job data can be defaulted and setup based on the rules?	PeopleSoft Functional	01/05/2012 - 4:58am

Main Menu

User login

Quick links

Sponsored links

Recent blog posts

Who's new