Cisco Cisco Unified Contact Center Enterprise 9.0(2) User Guide
20
Cisco ICM Software Custom Screen Builder Guide
Chapter 3 Creating a New Report Template
Step 4: Create the SQL Statement
How to Create the Retrieval Argument(s)
About Retrieval Arguments for WebView Reports
When they generate a report, WebView users specify retrieval criteria whose values are
passed to the template. To enable your template to use these values, you must define
corresponding retrieval arguments in your SQL select statement.
passed to the template. To enable your template to use these values, you must define
corresponding retrieval arguments in your SQL select statement.
Each WebView template must include a specific set of retrieval arguments:
•
All templates must include an argument that retrieves a list of IDs for the report
category. For example, call type templates must include an argument that retrieves
a list of call type IDs. The data type of the ID argument is always NumberArray.
category. For example, call type templates must include an argument that retrieves
a list of call type IDs. The data type of the ID argument is always NumberArray.
•
Historical templates must also include start date and end date arguments. The data
type for both is DateTime.
type for both is DateTime.
Caution
These are the only arguments supported for WebView reports. Templates that include
arguments beyond those described here will fail to retrieve data in WebView.
arguments beyond those described here will fail to retrieve data in WebView.
How to Create the Retrieval Argument(s)
To create the template’s retrieval argument(s):
1.
From the InfoMaker Design menu, choose Retrieval Arguments. The Specify
Retrieval Arguments dialog box opens.
Retrieval Arguments dialog box opens.
2.
In the Name field, enter a name for the ID argument. The name should not include
spaces.
spaces.
Example: skill_set_id
3.
From the Type drop-down list, select NumberArray.
4.
If you are creating a historical report, click Add and create additional arguments
for the start and end date, using DateTime as the data type.
for the start and end date, using DateTime as the data type.
5.
Click OK. The Specify Retrieval Arguments dialog box closes.
How to Construct the Where Clause
The statement’s Where clause uses the retrieval arguments you created to limit data
retrieval to records that match certain criteria. If desired, you can add additional Where
criteria that do not use arguments to further narrow the scope of the report.
retrieval to records that match certain criteria. If desired, you can add additional Where
criteria that do not use arguments to further narrow the scope of the report.
To specify the Where criteria:
1.
In the SQL Toolbox, click the Where tab.