Variable Parameters in a Permalink
You can apply variable parameters on the fields or on the display name of a field, and on the parameters.
Note |
Permalinks with filters specified in the URL (also known as Variable Permalinks) are by default authenticated for reports. You can uncheck the check box to unauthenticate the variable permalink. Variable Permalinks do not support Excel and XML formats. |
Note |
You must not include both fields and parameters at the same time in a permalink. |
You can explicitly specify the filtering criteria by using either fields or parameters in a permalink to display the changed report data.
Format of the Parameters and Fields in a Permalink
You can include variable parameters to the default permalink using the following format:
<variable_param_name> or <field name>=<operator><space><value><space><value>
<variable_param_name> can be either the field name or parameter name as configured in the report definition of the report.
<value> is any valid value for the configured field.
To include multiple variable parameters in a permalink URL, use an & (ampersand) between two variable parameters.
Note |
The permalink with the variable parameter is one single URL. Do not break it into different lines. In this example, the URL is broken to explain the concept of variable parameters. You can have a space only between an operator and a value. |
Parameters
You can apply the variable parameters only on the parameter name for anonymous-block-based and stored-procedure-based reports.
Parameters are created from a stored procedure or an anonymous block.
- Example: Permalink with parameters
-
This example shows how you can include @start_date, @end_date, and @agent_list parameters to change the report data shown by a default permalink based of the values that are passed to these parameters.
- Default permalink
-
//localhost:8444/cuicui/permalink/?
viewId=5BC22D1C1000013C61E3571D0A4E5AF5&linkType=htmlType&viewType=Grid
- Parameter name 1:
-
&@start_date=ABSDATE 11-01-2012 00:00:00
- Parameter name 2:
-
&@end_date=ABSDATE 01-21-2013 23:59:59
- Parameter name 3:
-
&@agent_list=14527,14537
Fields
You can apply the variable parameters on a field name or its display name for a database-query-based report.
Fields are created from a database query.
- Example: Permalink with fields
-
This example shows how you can include variable parameters to a permalink URL based on the fields EventTime and User to change the report data shown by a default permalink based of the values that are passed to these fields.
- Default permalink
-
//localhost:8444/cuicui/permalink/?
viewId=5BC22D1C1000013C61E3571D0A4E5AF5&linkType=htmlType&viewType=Grid
- Field name 1:
-
&EventTime=ABSDATE 11-01-2012 01-21-2013 00:00:00-23:59:59 MON,WED
- Field name 2:
-
&User=VL CUIC%5Cadministrator
The EventTime field retrieves the report data based on the absolute date value ABSDATE 11-01-2012 01-21-2013 00:00:00-23:59:59 MON,WED.
The User field retrieves the report data based on the value &User=VL CUIC%5Cadministrator.
-
& is the separator that separates two variable parameters.
-
User is the second field.
-
VL is the second operator that works on the values CUIC%5Cadministrator.
-
CUIC%5Cadministrator is the value that is passed to the User field.