System Administration

Page Validation Rules H

Page Validation Rules V

To access this page:

  1. Select Admin > WebApps in the Navigation pane.
  2. Click the Pages icon for a WEB APP NAME.
  3. Click the Events icon for a page.
  4. Click the Validation Rules icon for an event.

Field

Description

SQL

This icon is not used.

PRIORITY

Displays order in which the validations are executed.

VALIDATION TYPE

Displays the type of validation for the selected page.

Options are:

  • External Page – Validation plugins can be created internally right now, but points to code that will execute against the record and return validation results if they exist.

  • Stored Procedure – This setting executes a procedure to determine whether the associated record is valid. Returning a non-zero result will result in failing the validation.

  • View – This setting binds the view against the current column key to determine validity. If the view returns any results, the validation rule is considered failed.

NAME

Displays the name of the name of the validation which is computed based on the type of the validation and the entity chosen (whether it’s a view, procedure, or plugin), for example, webdcsMARA_FullConstruct_DSP9587DupKeyVal.

SEVERITY

Displays the severity level for the validation type for the selected page.

Options are:

  • Error – If the record fails this validation, the status will be marked as invalid. Business rules not marked to “Run on Fail” will not run. If this is a row level validation, an inline red bordered text box will appear with the validations text.

  • Message – This severity is an informative validation rule which works the same as other validation types but will not negatively affect (for example, failing a message will not fail the record validation) the validity of the record itself. This will show in the UI with a blue border.

  • Warning – If the record fails this type of validation they will be prompted to click Yes or No on whether to pass or fail the record. If passed, all business rules set to “Run on Pass” will run. If not, only the ones set to “Run on fail” will run and the record will be marked accordingly. This type of validation will show with a yellow border.

  • Workflow Only – Deprecated.

COMMENT

Displays the text when records fail this validation.

ACTIVE

If checked, the Validation rule is executed. If not checked, the Validation rule is not executed.

Page Validation Rules V

Page Validation Rules H

This page has the following tabs:

General tab

Field

Description

Validation Rule Properties

PRIORITY

Displays order in which the validations are executed.

View

Displays the name of the SQL view associated with the validation.

Active

If checked, the Validation rule executes.

If not checked, the Validation rule does not execute.

Severity

Displays the severity level for the validation type for the selected page.

Options are:

  • Error – If the record fails this validation, the status will be marked as invalid. Business rules not marked to “Run on Fail” will not run. If this is a row level validation, an inline red bordered text box will appear with the validations text.

  • Message – This severity is an informative validation rule which works the same as other validation types but will not negatively affect (for example, failing a message will not fail the record validation) the validity of the record itself. This will show in the UI with a blue border.

  • Warning – If the record fails this type of validation they will be prompted to click Yes or No on whether to pass or fail the record. If passed, all business rules set to “Run on Pass” will run. If not, only the ones set to “Run on fail” will run and the record will be marked accordingly. This type of validation will show with a yellow border.

  • Workflow Only – Deprecated.

COMMENT

Displays the text that displays when records fail this validation.

Advanced

Conditional Column

Displays the column name in the view that allows for a 0 (disabled) or 1 (enabled) value to determine whether this Validation rule executes. This can be useful when, for example, ensuring a field has a non-NULL value when another column is enabled.

Duplicate Detection View

Displays the name of the view that is used for the validation view used to select the duplicates in the Duplicate Detection process. This view allows the developer to customize the columns displayed and reduce the rows returned.

When the duplicate detection is run as part of validation and a possible duplicate is returned, the user can click the in-line validation message to view the possible duplicates.

If this field is blank, the underlying table is used for the validation view, and all columns in the table are searched for duplicate. In this case, the result set is larger. The primary key and duplicate detection columns are included in the result.

Refer to Manage Duplicate Detection for more information.

Documentation tab

External Reference

Displays hyperlinks and supporting commentary that demonstrate the connection from data-related assets in the DSP to external references in other platforms and applications.

Syniti recommends a validation rule be linked to a Term or Rule in Syniti Cloud.