Lucent Technologies CentreVu Report Designer, User Manual

Page: 111 / 266

Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query
7-9
If you are creating a Historical query, a Unique check box displays
next to the SELECT box. Select this check box to make this query
unique in the current report. What this means is that, if the query
returns multiple rows of the same data, then only one row of the data
will display on the report.
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. The SELECT box
specifies which
columns of data to consider in the database table(s).
The WHERE box species which
rows of data to consider in the
database table(s).
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.
The information displayed in the SELECT box cannot be
edited.