Table of Contents

Search

  1. Preface
  2. Introduction
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Step 5: Specify the Where criteria

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:
  1. Choose the column (field) for the compare.
  2. Choose the operator (=, >, >=, <, <=, <>, etc.) for the compare.
  3. 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
      F
      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.
  4. 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.
  5. 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.

0 COMMENTS

We’d like to hear from you!