Cisco Cisco E-Mail Manager Unity Integration Option Technical References
3-5
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Chapter 3 Creating New Custom Templates
Create the SQL Statement
Figure 3-1
The Select Painter
The Select Painter is the graphical object you use to build a basic SQL statement. By default, it appears
with the Select Tables dialog box open for your table selection.
with the Select Tables dialog box open for your table selection.
To define the SQL statement, you perform four required procedures and one optional procedure. These
procedures are:
procedures are:
•
from the database
1
that will be used for the report. (See page 7.)
•
from which the data will be retrieved. (See page 7.)
•
— a total of one argument for a real-time
template and three for an historical one. (See page 8.)
•
to limit the retrieval argument(s). (See page 9.)
•
. (See page 10.)
The next few pages present all of these procedures.
Note
InfoMaker allows you to incorporate elements in SQL statements that are not covered in this guide (for
example, Group By). For information on these additional elements, consult your InfoMaker
documentation.
example, Group By). For information on these additional elements, consult your InfoMaker
documentation.
Graphical or Syntax Environment?
This section describes how to create the SQL statement in the graphical Select Painter environment. You
can also write the SQL statement in a text window.
can also write the SQL statement in a text window.
Tabs
Table Select
Window
Window
Sort
Window
Window
1. Tables are described in-depth in the Database Schema Handbook for Cisco ICM/IPCC Enterprise & Hosted
Editions .