Cisco Cisco IPCC Web Option Technical References
C-2
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Appendix C Considerations and Tips for Working with Custom Reports
Custom Template Name Changes
Custom Template Name Changes
If the name of a custom template changes, saved reports using that template are no longer accessible.
The name of the template is one of the parameters saved in the report-definition record stored for a saved
report.
report.
The saved report record is NOT automatically updated to reflect a name change for a custom template.
Changing the custom template name therefore invalidates the saved report definition, and WebView
cannot create the report.
Changing the custom template name therefore invalidates the saved report definition, and WebView
cannot create the report.
You need to create a new saved report that uses the new (changed) template name.
Database Error
You will see a Database Error message if you import SQL code into InfoMaker and that SQL code
references a database that InfoMaker is not connected to.
references a database that InfoMaker is not connected to.
For example if the SQL calls a table in a custom database, the SQL might run with no errors in SQL
Query Analyzer. However, the same SQL would generate an error from InfoMaker.
Query Analyzer. However, the same SQL would generate an error from InfoMaker.
If you need to access delivered Unified ICM/CCE database tables, you must add views of those tables
to your custom database. For example, to view Agent information with your custom table(s), you would
create a view of the Agent table as follows:
to your custom database. For example, to view Agent information with your custom table(s), you would
create a view of the Agent table as follows:
CREATE VIEW AgentCust AS
SELECT t.*
FROM devry_awdb.dbo.t_Agent t
SELECT t.*
FROM devry_awdb.dbo.t_Agent t
Doing this allows you to access data in other tables, provided you add a view for each table in your
custom database.
custom database.