Using Query Drilling URLs in Pivot Grid Models
PSQuery supports drilling URLs that enable you to navigate to either a PeopleSoft Pure Internet Architecture page, another query result page, or an external page. These drilling URLs can contain context-sensitive bind values obtained from the query result row. For example, a drilling URL enables you to navigate to a component by taking key values from the row where you click a cell. You use PeopleSoft Query - Query Manager to define drilling URLs.
See Understanding Drilling URLs.
Pivot Grid supports the following drilling URL types:
Component URL
Query URL
External URL
Free Form URL
Note: The Attachment URL type in PSQuery is designed for Search Framework and is not available to any other subproducts, including PeopleSoft Pivot Grids.
To use the drilling URLs in Pivot Grid, the Content URI Text and Portal URI Text fields in the Portal page of the default local node must have the valid values. To access the Portal page, select PeopleTools, Integration Broker, Integration Setup, Nodes, Portal. See Defining Portal Nodes
In this example of component drilling URL settings, the target component has keys INV_ITEM_ID and SETID mapped to the Key Value from the query field. At runtime, the values from the A.INV_ITEM_ID and A.SETID fields are passed as component keys. In the detailed view of the Pivot Grid, the mapped fields are shown as links. Clicking the URL links on the Detailed View enables you to access the target component.
Note: The Pivot Grid Wizard does not have any configuration for drilling URLs. If a drilling URL is defined in PeopleSoft Query - Query Manager, then it is available in the detailed view in the mapped columns. Using PeopleSoft Query - Query Manager, you can include the drilling URL as a field. If you include a drilling URL as a field, the drilling URL column should be set as a display-only column type in the Pivot Grid Wizard – Specify Data Model Values page.
In the following examples, the drilling URL is set to Query URL type, and the message set number from the detailed view is passed as a prompt (MESSAGE_SET_NBR) to the target query MESSAGES_FOR_MSGSET and run.
Drilling URLs are available in the detail grid and list views (the results view). The results grid columns that are mapped to query drilling URL are displayed as links. Note that in fluid viewer, you can set the display type of the target page to Full Page Modal, Modal Window, New Window, or Replace Window using Pivot Grid Wizard (Specify Data Model Options page, Fluid Mode Options section, Drilling URL Options subsection.) The drilling URLs is also available in the detail view that you open by clicking the grid data point.
Note: Drilling URLs are not available in the list view.
See Fluid Mode Options.