|
Portal Template Usage Report
Determining which pages will be affected when changing a portal template is not something that Oracle Portal gives you out of the box. However, creating a report that shows you this information is not difficult to do (once you know how to get the data!)
First, using a database provider create a List of Values called "All Templates" The query to generate this LOV is below
select distinct b.name || '-' || a.name as displayName, a.id
from portal.wwpob_page$ a, portal.wwsbr_sites$ b
where a.is_template = 1
and b.id = a.siteid
order by displayName
This LOV will display the page group name followed by the name of the template. Just modify the select statement to format this information to meet your requirements.
Next create a sql based report based on the following query.
select portal.wwpob_page_util.get_page_url(id,siteid)as url
from portal.wwpob_page$
where template_id = :templateId
order by url
Associate the LOV with the templateId bind variable and publish the report as a portlet on a page.
To select a template from the LOV, you must select the personalize link on the portlet.
Sean Scott
Solutions Architect
For additional questions regarding this tip contact techtips@sagelogix.com.
|
