User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Step 5: Specify the Where criteria

Click the tab labeled Where. The Where criteria allows you specify which rows (records) to retrieve from the table(s). Multiple lines of criteria can be entered. Follow the steps below to add Where criteria:

Choose the column (field) for the compare.

Choose the operator (=, >, >=, <, <=, <>, etc.) for the compare.

Choose the Value Type and specify the Value.

Constant - For comparing the column against a constant value (for example, Country = 'USA'). For the Value, specify the constant (number or string) for the compare.

Column - For comparing the column against another column in the table (for example, ShipDate <> OrderDate). For the Value, choose the column for the compare.

Function - For comparing the column against a SQL Function (for example, BillDate = curdate() ). For the Value, either enter the name of the function or choose the function from a list by clicking the

button.

Parameter - For comparing the column against a parameter (for example, City = ?). This should only be specified when a parameter subelement is defined in the Project's SQL Task.

If additional lines of Where criteria need to be entered, then choose the conjunction under the AND/OR column and click the

Add Where

link. Repeat steps 1-3 above for the new row of Where criteria.

Additional functions:

Delete a row of Where criteria by selecting its check box and clicking the

Delete Rows

button.

Move a row by selecting it and dragging it up or down.

Use parenthesis to change the order of the Where criteria by entering one or more left parenthesis under the ( column and one or more right parenthesis under the ) column.

Rename Saved Search

Table of Contents

User Guide

User Guide

Step 5: Specify the Where criteria

Step 5: Specify the Where criteria