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.
Summary of Contents for CentreVu Report Designer
Page 4: ......
Page 18: ...Introduction CentreVu Report Designer Version 8 User Guide Related Documents 1 8...
Page 102: ...Edit Inputs CentreVu Report Designer Version 8 User Guide Viewing the Input Window 6 16...
Page 198: ...Format Text CentreVu Report Designer Version 8 User Guide Formatting Text on the Report 15 4...
Page 264: ...Index CentreVu CMS R3V8 Upgrades and Migration IN 10...
Page 266: ......
