myPeopleSoft

PeopleSoft Community Network

Drill Down PS Query in Peoplesoft

Purpose of Drill Down Query:

Wouldn't it be nice if they could just click on a hyperlink embedded within the query results and have the page pop up in a separate browser window instead?

As a solution to this kind of situation we need to use Drill down PS query instead of Normal.

It is a special type of expression which will return the respective URL for the column along with the PS Query Search Results.

Types:

1. Query URL

· Select Query URL if you want your URL to point to a different query result.

· By clicking hyperlink in search result it will execute the child query(Based on the mapped field in search result).

2. Component URL

· Select Component URL if you want to open up a transaction page.

· By clicking hyperlink in search result it will redirect us to the respective transaction page.

3. External URL

· Select External URL if you want to open up an external page like Google.

· By clicking hyperlink in search result it will redirect us to the external page in a new tab.

4. Attachment URL

· Select Attachment URL if you want to open up an attachment by clicking on the link.

5. Free form URL

· Select Free Form URL to create your own type of URL

Step by Step Instruction to Setup the Drill down URL:

Read Further: http://peoplesoftblog4u.blogspot.com/2013/06/9-drill-down-ps-query_...

0 members like this

Permalink Reply by Allie Alderson on November 12, 2013 at 7:59am

Thanks for sharing.

Welcome to
myPeopleSoft

Sign Up
or Sign In

Or sign in with: