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:
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.
Here are two example drilling URL expressions. Like any other expression, they can be included in the field list and used as data.
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.
Finally, you can use your query’s drilling URL as the hyperlink by doing the following:
Voila. You’re done!