Welcome to CompShack!
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!

Contribute!

Contribute!Do you find yourself with few minutes to spare, and a desire to help other CompShackers?

Submit a tip, code or an SQL snippet. Start an article about topics you are familier with, or edit a Wiki page. Help the community grow larger by sharing a little bit of what you know!

Reasons why this is great:

  • You help your fellow CompShackers
  • Give back to the community and help it grow
  • Easy access to your code any time you need it
  • Become known and adored in the community!

Note: Registration required. Guests can edit Wiki pages.

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!

Unwanted Save Warnings in Display Only Pages

Use function

SetSaveWarningFilter( True);

Breadcrumb SQL to find the Navigation path for the component in the PIA

Breadcrumb SQL:

WITH parent (breadcrumb, portal_label, portal_objname, portal_prntobjname, portal_reftype, component) AS
(SELECT varchar(rtrim(portal_label), 1000)
, portal_label
, portal_objname
, portal_prntobjname
, portal_reftype
, RIGHT(portal_urltext, length(portal_urltext) - locate('.', portal_urltext))
FROM psprsmdefn
WHERE portal_name = 'EMPLOYEE'
AND portal_reftype = 'C'
UNION ALL
SELECT varchar(rtrim(c.portal_label), 1000) || ' > ' || p.breadcrumb
, c.portal_label
, c.portal_objname
, c.portal_prntobjname
, c.portal_reftype
, p.component

Application Designer Index naming convention

The indexes generated by the Application Designer have the following naming convention:

INDEX_NAME = 'PS '||{index_id}||{peoplesoft record name}

Index ID : Description

_ : PeopleSoft key index. Implied from the record definition.

1–9 : Alternate search key indexes. Implied from the record definition.

# : List index. Implied from the record definition. Only applicable in PeopleTools 7.5 and earlier; not used in PeopleTools 8.

A–Z : User-specified index.