Tuesday, June 20, 2006

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.

2 comments:

Jayalakshmi said...

Hello, I am trying to add a Peoplesoft URL to the query as mentioned. It works fine. When i add the Prompt value to the Peioplesoft URL, then it states "Sql Error". Please suggest.

q/?ICAction=ICQryNameURL=PUBLIC.AX_OTR_LIST_POSN_EMP_DET&BIND1="1901-01-01".

Any help is highly appreciated.

Thanks!
Jayalakshmi S

Jayalakshmi said...

q/?ICAction=ICQryNameURL=PUBLIC.AX_OTR_LIST_POSN_EMP_DET&BIND1=1901-01-01.

When you pass the Bind value it should not have Quote.