Lucent Technologies CentreVu Report Designer, User Manual

Page: 122 / 266

Edit | Queries CentreVu Report Designer Version 8 User Guide
Editing an Existing Real-Time or Historical Query
7-20
7. In the Operand1 box, highlight the first database item or calculation
which you want considered in the WHERE clause.
8. In the Operator box, highlight the appropriate operation.
9. In the Operand2 box, highlight the second database item or
calculation which you want considered in the WHERE clause.
For example, if you wanted the report to select the data from the
table when the number of ACDCALLS is greater than the number of
ACWINCALLS, then you would select acdcalls in the Operand1 box,
the > sign in the Operator box, and ACWINCALLS in the Operand2
box.
10. Select the AND or the OR button, as appropriate.
If you place “and” between clauses, then both of the clauses must
be true in order for CMS to retrieve the SELECT data from the table.
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.
11. Repeat Steps 7 through 10 until you have completed the query.
You can add your own text in the WHERE clause (such as
parenthesis and numbers) by placing your cursor where you would
like the text to appear and then typing in the text.
12. Select the Test button.
CMS checks the syntax of the query and returns a message with
any errors.
13. Correct any of the errors detected in the Test.
14. Select the Save button.
15. The changes to the query are saved and the Query Select window
displays.
AND
button Places an AND before the currently selected Operand1,
Operator, and Operand2.
OR button Places an OR before the currently selected Operand1,
Operator, and Operand2.
New Input Takes you to the Edit Inputs window, where you can add
new input fields for the Report Input window.
Test
button Allows you to test the query for basic SQL syntax errors.
Item Purpose