While back, I've created an SQL to find the exact same thing but with some level limitations. I have came across another query written by Jim's PeopleSopft Journal blog that works a little bit better and thought to share it with my visitors.
Jim's query however requires the developer to know the content reference of a component before the query could be used. What I really wanted is the ability to find the path by just knowing the component and not the content reference. Chances are, if you know the component reference you know the path to that component as well. So, to find the component path without knowing the content reference, follow the steps below:
1) Run the below SQL to get the content reference name for your component
2) From the query above - copy the value in the CONTENT_REFERENCE field and replace the ":1" variable and you will have the path to your component.
So, the 1st query is to get the content reference for a component name that you know and then using Jim's query to find the path!
|how to send hyperlink with email in application engine program.||PeopleSoft Technical||06/13/2013 - 12:55am|
|Saving records||PeopleSoft Technical||06/04/2013 - 11:11am|
|can we alter a trigger in DB2 to add a new column||SQL & PL/SQL||05/29/2013 - 1:31am|
|Required Peoplesoft HRMS Functional Training||PeopleSoft Functional||05/07/2013 - 10:29pm|