1. Study Setup Guide
  2. Create validation checks
  3. Complete a validation check without a custom program
  4. Specify validation check criteria

Specify validation check criteria

In the Criteria tab, specify the data condition the validation check is looking for. This becomes the WHERE clause.

Either:

  • Enter the code directly in the Criteria pane.
  • Click the Icon shows letters and a pencil.Add or Modify Criteria icon to open the Expression Builder. See Use the Expression Builder for details.

    Important:

    • If you reference a static package or function in free text, you must select it in the Selected Packages tab.

    • In free text, use just the column name, not the table.column format, unless you need to use an alias, as in a self-join. In that case the alias.column format is required.

Next: Generate, test, view, and save source code.

Parent topic: Complete a validation check without a custom program