User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
Content References Accessed by a Permission List
Wed, 10/01/2008 - 2:21pm — Lepa
We are only interested in translate value of 'TARG' (target) from field portal_cref_usgt on table psprsmdefn. Other available translates on that field are:
FRMT = Frame template
HPGC = Pagelet
HPGT = Homepage tab
HTMT = HTML template
LINK = Content Reference Link
Another permission list query to list Content References accessed by a specific Permission List.
SELECT a.portal_label AS PORTAL_LINK_NAME, a.portal_objname, a.portal_name, a.portal_reftype
FROM psprsmdefn a, psprsmperm b, psclassdefn c
WHERE a.portal_reftype = 'C'
AND a.portal_cref_usgt = 'TARG'
AND a.portal_name = b.portal_name
AND a.portal_reftype = b.portal_reftype
AND a.portal_objname = b.portal_objname
AND c.classid = b.portal_permname
AND a.portal_uri_seg1 <> ' '
AND a.portal_uri_seg2 <> ' '
AND a.portal_uri_seg3 <> ' '
AND c.classid = :permissionlist
AND a.portal_name = :portalname
ORDER BY portal_label;
FROM psprsmdefn a, psprsmperm b, psclassdefn c
WHERE a.portal_reftype = 'C'
AND a.portal_cref_usgt = 'TARG'
AND a.portal_name = b.portal_name
AND a.portal_reftype = b.portal_reftype
AND a.portal_objname = b.portal_objname
AND c.classid = b.portal_permname
AND a.portal_uri_seg1 <> ' '
AND a.portal_uri_seg2 <> ' '
AND a.portal_uri_seg3 <> ' '
AND c.classid = :permissionlist
AND a.portal_name = :portalname
ORDER BY portal_label;
We are only interested in translate value of 'TARG' (target) from field portal_cref_usgt on table psprsmdefn. Other available translates on that field are:
FRMT = Frame template
HPGC = Pagelet
HPGT = Homepage tab
HTMT = HTML template
LINK = Content Reference Link
It is important to note that knowing the content reference will make it easy to find the path (PIA navigation) for that content ref. Here is a post to help you with that.
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!
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 |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About Lepa
Job title
Application Developer
Poll
New forum topics
- MD5 - SHA checksum of a file.
- nVision Tabular Report through PIA with prompts
- Enable/Install GP and T&L modules on existing HRMS System
- How to get the list of tables having specific field as key.
- How to populate data into grid, click on pushbutton
- peoplesoft
- Can we create an AE to mass update Position - Jobcode data?
- How to do the Upgradation from one version to another version
Recent comments
- Re: Component Permission List Query
5 days 20 hours ago - Re: How to populate data into grid, click on pushbutton
6 days 4 hours ago - Re: Arrays in PeopleSoft
1 week 21 hours ago - Re: I want to add a hyperlink to a peoplesoft delivered ...
1 week 22 hours ago - Re: How to get the list of tables having specific field as key.
1 week 22 hours ago - Re: I want to add a hyperlink to a peoplesoft delivered ...
1 week 5 days ago - Re: inserting rows within standalone rowset without fill
1 week 5 days ago - Re: How to populate data into grid, click on pushbutton
1 week 5 days ago - Re: Name change Workflow using PS role query
1 week 6 days ago - xml publisher
2 weeks 1 min ago
Comments
Hello,
Sometimes in Peopletools->Portal->Structure and Content
We might hide some Portal links, So it is better include the following in the SQL
AND NOT EXISTS (SELECT '1' FROM PSPRSMSYSATTR d WHERE d.PORTAL_OBJNAME=a.PORTAL_OBJNAME
AND PORTAL_ATTR_NAM='PORTAL_HIDE_FROM_NAV')
-------------------------------------------------------------------------------
SELECT a.portal_label AS PORTAL_LINK_NAME, a.portal_objname, a.portal_name, a.portal_reftype
FROM psprsmdefn a, psprsmperm b, psclassdefn c
WHERE a.portal_reftype = 'C'
AND a.portal_cref_usgt = 'TARG'
AND a.portal_name = b.portal_name
AND a.portal_reftype = b.portal_reftype
AND a.portal_objname = b.portal_objname
AND c.classid = b.portal_permname
AND a.portal_uri_seg1 <> ' '
AND a.portal_uri_seg2 <> ' '
AND a.portal_uri_seg3 <> ' '
AND c.classid = :permissionlist
AND a.portal_name = :portalname
AND NOT EXISTS (SELECT '1' FROM PSPRSMSYSATTR d WHERE d.PORTAL_OBJNAME=a.PORTAL_OBJNAME
AND PORTAL_ATTR_NAM='PORTAL_HIDE_FROM_NAV')
Thanks Sakthi, really appreciate your feedback.
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
Post new comment