Troubleshooting guide

February 2006 119
Field descriptions
This window includes the following fields:
The ACD operand is automatically added to the beginning of each WHERE clause.
Item Description
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.
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, calculations, and inputs that can be used in the
WHERE clause and as inputs for the input window.
WHERE box Shows the current WHERE clause.
AND button Places an AND before the currently-selected Operand1, Operator, and
Operand2. 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.
OR button Places an OR before the currently-selected Operand1, Operator, and
Operand2. 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.
New Input Takes you to the Edit Inputs window, where you can add new input
fields for the Report Input window. Any new inputs you add will display
in the Operand2 box.
Test button Allows you to test the query for basic SQL syntax errors.