Defining Component Drilling URLs

The Component URL widget enables you to use the Select a Component page (QRY_COMPURL_SELECT) to build drilling URLs in component URL format. When you click the Component URL link in the Edit Expression Properties page to access the Select a Component page, a PeopleSoft Pure Internet Architecture page is launched.

Note: The Component URL widget is only used for pages that have the Action field set to Update/Display.

Navigation

  1. Select Reporting Tools > Query > Query Manager.

  2. Select the Expressions tab, and click the Add Expression button.

  3. Select the Drilling URL option from the Expression Type list and click the Component URL link.

Image: Select a Component page

This example illustrates the fields and controls on the Select a Component page. Definitions for the fields and controls appear following the example.

Select a Component page

Field or Control

Definition
Portal Name

Optionally, enter or select a portal that is used to build drilling URLs at the report runtime.

Note: If the Portal Name field has no value, PeopleSoft Query uses the value %PORTAL to form a drilling URL at the report runtime.
Node Name

Optionally, enter or select a node that is used to build drilling URLs at the report runtime.

If the Node Name field has no value, PeopleSoft Query uses the value %NODE to form a drilling URL at the report runtime.
Use psc (content servlet)

Used to define the content type that is used to build drilling URLs.

  • Deselect this option to use the portal service (psp) type.

    By default, this option is deselected.

  • Select this option to use the content servlet (psc) type.
Content Reference

Enter the name of a content reference or use the Add Content Reference Link link to select a content reference from an existing list.

See Administering Content References.
Add Content Reference Link

Click to access the Select a Content Reference or Content Reference Link page, where you can select a content reference or content reference link.

Note: The values of the Menu Name, Market, and Component fields are populated if you select a content reference or content reference link using the Add Content Reference Link link.
Menu Name

Enter a menu name or click the lookup icon and select one menu name from an existing list. Otherwise, the menu name value is populated if you select a content reference or content reference link using the Add Content Reference Link link.
Market

Enter a market code or click the lookup icon and select one market code from an existing list. The market code is populated automatically if you select a content reference or content reference link using the Add Content Reference Link link.
Component

Enter a component name or click the lookup icon and select one component name from an existing list. Otherwise, the component name value is populated if you select a content reference or content reference link using the Add Content Reference Link link.
Menu Action

Select an action type to associate with the component.

When you run the query, a component drilling URL expands with correct action mode within the URL. For different component actions, the drilling URL will be constructed differently. When you click the component drilling URL from the query results page, it opens the target component with the correct action mode. The available menu actions are:

  • Add

    The URL will include Action=A.

    Clicking the URL opens the target component at the Add a New Value page.

  • Update/Display

    The URL will include Action=U.

    Clicking the URL opens the target component at the Find an Existing Value page.

  • Update/Display All

    The URL will include Action=L.

    Clicking the URL opens the target component at the Find an Existing Value page with the Include History option selected by default.

  • Correction

    The URL will include Action=C.

    Clicking the URL opens the target component at the Find an Existing Value page with the Correct History option selected by default.

Note: The Menu Action lists the actions that were granted to the selected component when the component was created using Application Designer.

If you have defined mapping between query result columns and all of the component search key fields, then clicking the component drilling URL will bypass the search page and open the main page directly.
Search Keys

Click to select mapping between component search keys and source query result columns.

If the entered component has a search key, a list of those search keys appears in the URL Keys section. If the entered component has no search key, a message appears saying “Component does not contain any search keys”.

Note: This step is optional. If you do not map any search keys to the source component, then when you click a drilling URL link in the query result column page, you will be directed to a component search page, where you can select search key values.
Select Field

Click to display the Select Query Column section.
Map Columns

Click to display the Map URL to Query Columns section.

Note: This step is required for the drilling URLs to be available in query results page.

You can define multiple drilling URLs in a query, but each query result column can only bind with one URL. When you click the Map Columns button, only those fields that have no bond with any URL appear in the Map URL to Query Columns section. If all query columns have bonds with other tracking URLs, then a message appears saying “All columns have already been mapped to other drilling URLs.”
URL Keys

The URL Keys section is available only after you define the component and click the Search Keys button.

In this URL Keys section, you define value mapping between Drilling URL destination component search keys and Drilling URL source query result column fields.

To map these fields, you can either select the key field and then click the lookup icon to select source query column field to map to it, or enter static values as mapping value directly into the Field Value field. Similarly, in the Key Value field, you can either manually enter the key name or search for existing keys from the component. You can also add or delete key values using the Add or Delete button.

Note: This step is optional. If you do not map any search keys to the source component, then when you click a drilling URL link in query result column page, you will be directed to a component search page, where you can enter search key values before you launch the component.
Select Query Column

Select query result columns to form fieldname and value pairs and to define the order of the appended value pair in the URL.
Map URL to Query Columns

The Map URL to Query Columns section is available only after you define the component values and click the Map Columns button.

Note: This step is required for the drilling URLs to be available in the query results page.

Use the Map Columns button for binding source query result column fields with a Drilling URL. You must map URLs to query result columns in order for the drilling URLs to be available as links in column fields of the source query results. You can define column mapping by selecting the appropriate check box in this Map URL to Query Columns section.
OK

Click to finish defining a Component URL widget and return to the Edit Expression Properties page.

Use the Select a Content Reference or Content Reference Link page (QRY_CREFURL_SELECT) to select a content reference or content reference link.

Navigation

  1. Select Reporting Tools > Query > Query Manager.

  2. Select the Expressions tab, and click the Add Expression button.

  3. Select the Drilling URL option from the Expression Type list, and click the Component URL link.

  4. Click the Add Content Reference Link link.

Image: Select a Content Reference or Content Reference Link page

This example illustrates the fields and controls on the Select a Content Reference or Content Reference Link page.

Select a Content Reference or Content Reference Link page

To select a component to build drilling URLs:

  1. Select Reporting Tools > Query > Query Manager.

    The Query Manager search page appears.

  2. Click the Create New Query link on the Query Manager search page to create a source query, or click the Search button and open an existing one.

  3. If you create a new source query, click the Search button and click the Add Record link to select a record for the query.

    The Fields page appears.

  4. Select the Expressions tab, and click the Add Expression button.

    The Edit Expression Properties page appears.

  5. Select the Drilling URL option from the Expression Type list.

  6. Click the Component URL link to define a drilling URL for the source query that you just created.

    The Select a Component page appears.

  7. Optionally, define the portal name, node name, or content type.

  8. Type a content reference in the text box or click the Add Content Reference Link link to select one from existing components.

  9. If needed, define the values for the Menu Name, Market, and Component fields.

  10. Optionally, define value mapping in the URL Keys section.

    In the Field Value and Key Name fields, either use the lookup icon to select a source query column field to map to it, or enter static values as mapping value directly into the fields.

    Note: If the selected component has a search key, the URL Keys section appears with a list of search key fields after you click the lookup icon.

  11. Optionally, define query result columns for existing drilling URLs:

    1. Click the Select Field button to display the Select Query Column section.

    2. Select query result columns to form fieldname and value pairs and to define the order of the appended value pair in the URL.

  12. Optionally, define the map columns in the Map URL to Query Columns section.

    1. Click the Map Columns button to map the drilling URL to a source query selected column.

    2. Select appropriate values from the Map URL to Query Columns section.

  13. Click the OK button.

    The Edit Expression Properties page appears with a component drilling URL in the Expression Text field.

    This is an example of a component drilling URL with the Use psc option is not selected, and the Portal Name and Node Name fields have no values. Notice that, %PORTAL and %NODE values will be used to build URLs at the report runtime:

    'psp///c/QE_SAMPLE_APPS.QE_DEPT_TBL.GBL?Action=U&DEPTID=%A.DEPTID%&
    SETID=PLEASANTON:A.EMPLID'

    This is an example of a component drilling URL with the Use psc option is selected, portal CUSTOMER, and node QE_LOCAL:

    'psc/CUSTOMER/QE_LOCAL/c/QE_SAMPLE_APPS.QE_DEPT_TBL.GBL?Action=U&
    DEPTID=%A.DEPTID%&CITY=PLEASANTON:A.EMPLID'

    In this example, 'psc/CUSTOMER/QE_LOCAL is your selected portal name, node name, and content type; &DEPTID=%A.DEPTID is your static value as key value; and &CITY=PLEASANTON is your entered key name and key value.

    Note that, a component drilling URL:

    • Always includes /c/.

    • Is saved as part of expression metadata for the query.

    • Contains two parts: component URL format and query result columns binding with the drilling URL.

  14. Save your query.

  15. Select Reporting Tools > Query > Query Manager.

    Alternatively, select Reporting Tools > Query > Query Viewer.

  16. Click the HTML link or the Download to Excel link.

    The query results page displays results as links. When you click these links, destination query is run using the prompt key value that is defined using the source query.