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 Query: 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, Node Definitions, Portal. See Portal Technology: Defining Portal Nodes