Lucent Technologies CentreVu Report Designer, Руководство пользователя

Страница: 121 / 266

Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Real-Time or Historical Query
7-19
The Query Assistant “Enter the SQL WHERE criteria” window
appears, as shown below:
This window is where you will define the SQL “where” clauses that
will be used to retrieve data for the report. The SQL where clause
tells the CMS to retrieve the data defined in the SELECT box that
matches the criteria defined in the WHERE box.
For more information on SQL where clauses, see Chapter 18, “SQL
Query and CMS Database Tables Basics” in this document.
This window includes the following elements:
Item Purpose
SELECT
box Shows the Query Items that were defined on the previous
windows, including the database items and calculations
and any associated functions assigned to the items, and
the database table from which the database items and
calculations are to be retrieved.
Operand1
box Lists the database items and calculations that can be
used in the WHERE clause.
Operator
box Lists the standard mathematical operations that can be
used in the WHERE clause.
Operand2
box Lists the database items and calculations that can be
used in the WHERE clause.
WHERE
box Shows the current WHERE clause.