Lucent Technologies Centrevu Report Designer Version 8 User Guide

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-9
If you are creating a Historical query, a Unique check box displays 
next to the S
ELECT 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...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-10
The ACD operand is automatically added to the beginning of each 
W
HERE clause.
20. In the Operand1
 box, highlight the first database item or calculation 
which you want considered in the W
HERE clause.
21. In the O
perator box, highlight the appropriate operation.
22. In the Operand2
 box, highlight the second item (input, database 
item, calculation, or item defined in the Other box on the “Add...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query7-11
If you place “or” between clauses, then either of the clauses can be 
true in order for CMS to retrieve the SELECT data from the table.
24. Repeat Steps 20 through 23 until you have completed the query.
You can add your own text in the W
HERE clause (such as 
parenthesis and numbers) by placing your cursor where you would 
like the text to appear and then typing in the text.
If you are creating a...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating an Integrated Query7-12
Creating an Integrated Query7
To create a new query to be used in a Designer Report, complete the 
following steps from the Report Designer Design Mode window:
1. Select Query from the Edit menu.
The Query Select window appears:
2. Select the N
ew button.
The Query Assistant “Select a database and one or more tables for 
the query” window in appears:
3. Select the Database radio button next to Integrated.
The...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating an Integrated Query7-13
4. In the T
able list, highlight the name of the table which includes the 
database items or calculations that you want to include in the query.
For integrated reports, you can select one table per query.
For information on the database items and calculations available in 
each table, see the 
CentreVu® CMS R3V8 Database Items and 
Calculations 
document (585-210-939).
5. Select the N
ext button.
The Query...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating an Integrated Query7-14
9. Select the Next button.
The Query Assistant “Enter the start time for this integrated query” 
window appears:
10. Select the I
nput Start Time or Select Start Time Now radio button. 
If you select the Select Start Time N
ow radio button, you need to 
define the time that the integrated data will always begin 
accumulating for this report.
If you select the Input Start Time, a “Start Time” field will be...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating an Integrated Query7-15
11. Select the N
ext button.
The Query Assistant “Select the input used to indicate the xxx for 
this query” window appears:
On this window, you can choose the input item that will be used for 
the query.
12. Highlight the input(s) you would like to use as criteria for the query. 
You can create a new input by selecting the New Inp
ut button, 
which takes you to the Edit Inputs assistant.
Only the inputs that...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating an Integrated Query7-16
The Query Assistant “Enter a name for this query” window appears:
14. In the N
ame text box, type the name that you would like to assign to 
the query you created.
15. Select the D
one button. 

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Real-Time or Historical Query7-17
Editing an Existing Real-Time or Historical Query7
To edit an existing real-time or historical query used in a Designer Report, 
complete the following steps from the Report Designer Design Mode 
window:
1. Select Query from the Edit menu.
The Query Select window appears:
2. In the Q
ueries box, highlight the name of the query you would like to 
edit.
3. Select the E
dit button.
The Query...

  Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Real-Time or Historical Query7-18
4. If you would like to add database items or calculations to the Query 
Items list, highlight the item in the Database I
tems or Calculations 
box and then select the A
dd button.
If you would like to remove a database item or calculation from the 
Q
uery Items list, highlight the item in the list and then select the 
R
emove button.
If you would like to edit a database item or...