Wednesday, September 16, 2009

Create Portal Registry Content Reference for a Query


You can easily create a new Content Reference for running the Query directly from Left hand menu, without navigating thru Query viewer. This allows easy execution of query by end user.

The Query URL is of the following format

q/?ICAction=ICQryNameURL=PUBLIC.MYQUERYNAME

Go to Structure and Content and Create a new Content reference, with following properties

Usage Type : Target
Select No Template check box.
Node Type : Always use Local, if you want to run the query hosted locally
URL Type : PeopleSoft Generic URL
Portal URL : q/?ICAction=ICQryNameURL=PUBLIC.MYQUERYNAME
Note : No forward slash before q. Otherwise Portal template will not be removed.
Content Reference Attributes
Name : NAVNEWWIN
Attribute Value : true
Uncheck Translate check box.

This will open the query page in a new window with no Portal wrapper.

If you want to pass parameters to query URL, you need to add the following at the end
"&<unique prompt name>=<value>"

You can find the unique prompt name from prompt definition page.

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes