Blog

Drilling URLs and Pagelet WIzard

Created on Monday, 09 January 2012 21:11
Written by larry

I received an excellent question this week from an attendee of our Advanced Query Tips and Techniques session at the Quest Midwest conference.


In this session, I discussed using Queries in WorkCenter pagelets as a way of generating a list of items to be worked.  In order for the pagelet to link to a page, there needs to be a hyperlink to that page coming from the data in the query results.  Wouldn't it be nice to use the Drilling URL feature in Query to accomplish this (as discussed in the following blog entry)?


This would accomplish the following:

  • Allow easy definition of pages and queries to drill to (with parameters passed)
  • Allow the source of the pagelet to be created and maintained definitionally with security, translations, and administration already handled
  • Allow queries and pagelets to be migrated between environments without manual changes to make it work
  • Leverage a common definition for stand-alone queries and the source of pagelets

Although drilling URLs are not understood by Pagelet Wizard directly, the drilling URLs you create in your queries can be used in Pagelet Wizard for navigation.

Here are the steps.

Example Drilling URLs

Here are two example drilling URL expressions.  Like any other expression, they can be included in the field list and used as data.

You can take a drilling URL to navigate to pages or queries based on the query results. This expression can be used a filed for other purposes.

Defining the link in Pagelet Wizard

When using the query as the data source of a pagelet, you can click on the link icon to define the hyperlink for a given column (i.e. display field) in the pagelet.

To add a hyperlink to a column in the result set, click on the link icon.

Specifying Pagelet link Details

Finally, you can use your query's drilling URL as the hyperlink by doing the following:

  • Click on the External URL link type
  • Set the BASE URL to be specified by the data
  • Pick the expression field as the data to use (it's a fully qualified URL, so it will work).

Pick the link type of External URL and the Base URL to be specified by the query data. This will allow you to pick the drilling URL expression you put in your query fields


Voila.  You're done!

Drilling URL | pagelet | query | workcenter

Add your comment

Your name:
Comment:
yvComment v.2.00.2

News Archives

Recent Comments

Tags

2007 2008 2009 2010 bolt-on drilling events java mobile nvision openworld peoplecode process_scheduler products query reporting security support sysadmin telephony testing tree_manager upgrade versioncontrol webinar

Get in Touch

This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

+1 925-217-1298 x 201

Oracle Partner

© 2011 Grey Sparling Solutions.
All rights reserved.