Lucent Technologies CentreVu Report Designer, User Manual

Page: 224 / 266

SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
About SQL Queries
18-2
About SQL Queries
18
Reports use SQL queries to retrieve specific data from the database
tables. You can create and edit queries using the Edit | Queries feature of
the Report Designer. This section gives you information about SQL
queries, concentrating on the use of WHERE clauses. For extensive
information on SQL, please refer to your
INFORMIX documentation.
SQL queries use WHERE clauses to define the rows and columns of
data to retrieve from the database tables. The following paragraphs give
you information on how to create and use WHERE clauses in your
queries.
Basic WHERE
Clause
18
A basic clause has the following format:
Expression Relational_Operator Value
The
Expression
can be a database item or calculation. The
Value
is a whole number. Relational operators available for a WHERE clause
are as follows:
As an example of a basic WHERE clause, if you are creating a real-time
report using data from the Current Interval Split table and you have three
report fields for the report:
Split:
(the
SPLIT
database item)
ACD Calls:
(the
ACDCALLS
database item)
Average Talk Time:
(the calculation
ACDTIME/ACDCALLS
)
Then the WHERE clause might be:
Select rows where SPLIT = 5
= equal to
< > or != not equal to
> greater than
>= greater than or equal to
< less than
<= less than or equal to