Attaching Editable Facets to URLs

PeopleSoft supports bind parameters as part of URL query string. The query bind parameters are passed as query string values to the pivot grid viewer. This enables you to show the pivot grid any where. Similarly relevant values and operators in editable facets in the pivot grid viewer is passed to query string. The query string is attached to the URL. You can use this URL to replicate the same pivot grid view with same values and operators for editable facets.

URL format is as follows. The parameters are described further.

http://<hostname>:<port>/psc/<site>/<Portal>/<Node>/c/PTPG_WIZ_MENU.PTPG_NUI.GBL?Page=PTPG_NUI_VWR&Action=U&PGNAME=<PG Name> &VIEWNAME=<View Name>&<Unique bind parameteer name>=<bind value>&fctNames=<facet names separated by separator>&fctOper=<operators separated by separator>&fctValues=<facet values separated by separator>&fctSeparator=<separator value>

Field or Control	Description
fctNames	Facet names passed in the queryString.
fctOper	Operators for all the facet values passed in fctNames. The operators should be in the same order as facet values
fctValues	Values assigned to the facet names for all the facet values passed in fctNames. The values should be in the same order as the facet values.
fctSeperator	^ is used as a default separator. If ^ is available in one of the query string values being passed, the user may opt to use a different separator and pass it as fctSeparator.

The supported operators for a querystring are listed in the table.

Operator	Description
BET	Between
BET-	Not Between
LIS	In List
LIS-	Not In List
GRE	Greater Than
GRE-	Not Greater Than
LES	Less Than
LES-	Not Less Than
EQU	Equal To
EQU-	Not Equal To
LIK	Like
LIK-	Not Like