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 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.
-
Parent topic: Complete a validation check without a custom program