Field Evaluation Constraints

Owned by Sarah Oshunniyi (Deactivated)
Last updated: Jul 14, 2023 by HB Farris
4 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.