9. 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:

Step 1:

·         Once the query is created, Click Expression -> Add Expression Button.

step 2:

·         Select the expression type as Drilling URL.

step 3:

• Once Drilling URL is selected as the Expression type, their types will be highlighted.
•  Choose anyone URL type based on the requirement.  

step 4:

• After all the fields were entered, click the search keys button to populate all the search keys which is in our record.

step 5:

• If search keys are populated, then give their respective key value. The Selection flag for the particular field name should be selected to fill their key values.
•  These values will be used to By-pass the search key values while the component is redirected.

step 6:

• Click the Map column button to populate all the fields from the query record.
• Select the field that needs to be mapped. While the query the executed, on clicking a mapped field the component will be redirected in a separate tab in our browser.

step 7:

• “Use as field” hyperlink will be used to make the drilling URL expression as a new field and it will store in the database(optional).

• Drilling URL field will be added along with the Query search results.

step 8:

• Click the mapped fields or drilling URL hyperlink to redirecting the respective component in a new tab in our browser.

8. PeopleSoft Search Framework

PeopleSoft Search Framework:

# The PeopleSoft Search Framework consists of PeopleSoft components (pages and records provided by PeopleTools), which provide a centralized interface for configuring PeopleSoft integration with the search engine, creating search artifacts like search definitions, search categories, and building and maintaining search indexes. Currently the PeopleSoft Search Framework supports only Oracle Secure Enterprise Search (SES) as the back-end search engine.

Some of the key features are:

§  Search Administration interface provides a familiar PeopleSoft browser interface enabling you to: configure search engine connectivity, deploy search definitions, schedule index creation and maintenance, and run incremental index updates.

§  Search Designer interface, provides a familiar PeopleSoft browser interface enabling you to: create search definitions, create search categories, define title and summary result display (similar to Google search results).

§  Flexible security: indexes can be created with source-level security, document-level security, or no security. Oracle SES allows for fully authenticated and authorized search queries.

§  Search Query API enabling rich display options, such as filtering.

# The PeopleSoft database stores the PeopleSoft queries that define the search data as well as the search definition Meta data. Oracle Secure Enterprise Search stores the deployed search definitions and performs the typical search engine tasks, such as building indexes, crawling for updates, maintaining indexes, and servicing end-user search requests.

 Relation between Oracle Secure Enterprise search and PeopleSoft Search Framework:

# Oracle Secure Enterprise Search (SES) provides a familiar user interface to internet search users and gives secure access to all of your organization’s data sources—Web sites, file servers, content management systems, enterprise resource planning and customer relationship management systems, business intelligence systems, and databases.

# Oracle has created an embedded framework in PeopleSoft to integrate and communicate with SES, called PeopleSoft Search Frame Work.

# PeopleSoft Search Framework is a People Tools 8.52 indexed search technology that relies on Oracle SES (Secure Enterprise Search) engine by way of Integration Broker.

# Integration Broker provides the interface between PeopleSoft Search Framework and Oracle   SES engine to deploy the search definitions, build the indexes, and return the search results.

#  PeopleSoft Search Frame Work leverages indexes, and requires the use of PeopleSoft Query or Connected Query to create search definitions that identify the objects and attributes to make available to the indexes. 

# PeopleSoft Search Framework supports both application (global) and search pages (component) search capabilities. 

# Application search provides an alternate navigation mechanism that bypasses the classic PeopleSoft navigation.

# The Search Pages feature allows keyword-based searches within administrative components.

# Both searches target the PeopleSoft pages and components as if you navigated directly to them, while providing flexibility in searching. Users can choose to display the search results in list or grid format.

# As the Data is secured, so that search results return only data rows to which the user has role and permission list access