Field Evaluation Constraints

Owned by HB Farris
Last updated: Jan 23, 2024
5 min read

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.