Field Evaluation Constraints

1 Constraint Type: Field is Greater Than Or Equal
2 Constraint Type: Field is Empty
3 Constraint Type: Field is Equal
4 Constraint Type: Field is Less Than or Equal
5 Constraint Type: Field is Not Empty
6 Constraint Type: Field is Not Equal
7 Constraint Type: Field is Not One Of
8 Constraint Type: Field is One Of
9 Constraint Type: Field Contains

Constraint Type: Field is Greater Than Or Equal

Determines whether the specified integer field contains a value that is greater than or equal to the specified comparison value.

Required Properties

Type: Value must be Field Is Greater Than Or Equal
Name: The name of the field to evaluate.
Value: The value to compare against the field's current value. Must be an integer.

Optional Properties

None

Evaluation

True: The field's current value is greater than or equal to the comparison value.
False: The field's current value is less than the comparison value.

Example

Verify whether the Risk field is greater than or equal to 4.

{
  "Type": "Field Is Greater Than Or Equal",
  "Name": "Risk",
  "Value": "4"
}

Constraint Type: Field is Empty

Determines whether the specified field contains a value.

Required Properties

Type: Value must be Field Is Empty
Name: The name of the field to evaluate.

Optional Properties

None

Evaluation

True: The field has no value.
False: The field has a value.

Example

Verify whether the current record is missing a value in the Regulation field.

{
  "Type": "Field Is Empty",
  "Name": "Regulation"
}

Constraint Type: Field is Equal

Determines whether the specified field contains a value that is equal to the specified comparison value.

Required Properties

Type: Value must be Field Is Equal
Name: The name of the field to evaluate.
Value: The value to compare against the field's current value.

Optional Properties

Ignore Case: Yes or No; Ignore case-sensitivity during the comparison. No is the default behavior when this property is omitted. (i.e. Comparisons are case-sensitive by default.)

Evaluation

True: The field's current value is equal to the comparison value.
False: The field's current value is not equal to the comparison value.

Example

Verify whether the Type field is set to Data Migration.

{
  "Type": "Field Is Equal",
  "Name": "Type",
  "Value": "Data Migration",
  "Ignore Case": true
}

Constraint Type: Field is Less Than or Equal

Determines whether the specified integer field contains a value that is less than or equal to the specified comparison value.

Required Properties

Type: Value must be Field Is Less Than Or Equal
Name: The name of the field to evaluate.
Value: The value to compare against the field's current value. Must be an integer.

Optional Properties

None

Evaluation

True: The field's current value is less than or equal to the comparison value.
False: The field's current value is greater than the comparison value.

Example

Verify whether the Risk field is less than or equal to 3.

Constraint Type: Field is Not Empty

Determines whether the specified field does not contain a value.

Required Properties

Type: Value must be Field Is Not Empty
Name: The name of the field to evaluate.

Optional Properties

None

Evaluation

True: The field has a value.
False: The field has no value.

Example

Verify whether the current record has a Type.

Constraint Type: Field is Not Equal

Determines whether the specified field contains a value that is not equal to the specified comparison value.

Required Properties

Type: Value must be Field Is Not Equal
Name: The name of the field to evaluate.
Value: The value to compare against the field's current value.

Optional Properties

Ignore Case: Yes or No; Ignore case-sensitivity during the comparison. No is the default behavior when this property is omitted. (i.e. Comparisons are case-sensitive by default.)

Evaluation

True: The field's current value is not equal to the comparison value.
False: The field's current value is equal to the comparison value.

Example

Verify whether the Regulation field is not set to GxP.

Constraint Type: Field is Not One Of

Determines whether the specified field matches none of the specified values..

Required Properties

Type: Value must be Field Is Not One Of
Name: The name of the field to evaluate.
Values: The values to compare against the field's current value.

Optional Properties

Ignore Case: Yes or No; Ignore case-sensitivity during the comparison. No is the default behavior when this property is omitted. (i.e. Comparisons are case-sensitive by default.)

Evaluation

True: The field's current value is not equal to one of the comparison values.
False: The field's current value is equal to one of the comparison values.

Example

Verify whether the value in the Regulation field is not equal to GxP, SOX, or SOX & GxP.

Constraint Type: Field is One Of

Determines whether the specified field matches any of the specified values..

Required Properties

Type: Value must be Field Is One Of
Name: The name of the field to evaluate.
Values: The values to compare against the field's current value.

Optional Properties

Ignore Case: Yes or No; Ignore case-sensitivity during the comparison. No is the default behaviour when this property is omitted. (i.e. Comparisons are case-sensitive by default.)

Evaluation

True: The field's current value is equal to one of the comparison values.
False: The field's current value is not equal to one of the comparison values.

Example

Verify whether the value in the Type field is equal to Configuration, System, or Acceptance.

Constraint Type: Field Contains

Determines whether the specified field contains the specified content.

Required Properties

Type: Value must be Field Contains
Name: The name of the field to evaluate.
Value: The content to search for in the field's current content.

Optional Properties

Ignore Case: Yes or No; Ignore case-sensitivity during the comparison. No is the default behaviour when this property is omitted. (i.e. Comparisons are case-sensitive by default.)

Evaluation

True: The field's current content contains the comparison content.
False: The field's current content doesn't contain the comparison content.

Example

Verify whether the value in the Type field is contains System.