MattsBits
MattsBits

MattsBits

Return List of All Sub Pages In Oracle Portal  

by Matt Hawkins, 01/04/2011
Categories : Oracle

The following query can be used to return all the Oracle Portal pages within a particular page branch, including the level at which they appear in the tree.

SELECT
  id "ID",
  level "LEVEL",
  parentid "PARENTID",
  name "NAME",
  title "TITLE"

  FROM wwpob_page WHERE siteid=999 AND base_type=1
  
  CONNECT BY PRIOR id=parentid
  START WITH id=11111 AND siteid=999
  ORDER SIBLINGS BY TITLE;


where "11111" is the starting page id and "999" is the site id (page group id). Additional columns from the wwpob_page table can be added as required.

If you want to include a durable URL to each page you can include the following column in the SELECT statement :

'http://www.example.com:7780/portal/page/mydb/' || guid "URL"


Obviously you will have to modify the URL as appropriate to your system.

Author : Matt Hawkins  Last Edit By : Matt Hawkins
PHP Powered  MySQL Powered  Valid XHTML 1.0  Valid CSS  Firefox - Take Back The Web  EUKHost - Recommended Webhosting Solutions

MattHawkins CMS v3.0 - Copyright 2009-2017