Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel3
include
outlinefalse
indent
exclude
typelist
separatorbrackets
class
printablefalse

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 either Field Is At Least or 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.

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

Constraint Type: Field is Empty

...

  • 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.

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

Constraint Type: Field is Equal

...

  • 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.

Code Block
{
  "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 greater less than or equal to the specified comparison value.

Required Properties

  • Type: Value must be either Field Is At Least or Field Is Greater 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

Constraint Type: Field is Less Than or Equal

...

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 the specified comparison value 3.

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

Code Block
{
  "Type": "Field Is Less Than Or Equal",
  "Name": "Risk",
  "Value": "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.

Code Block
{
  "Type": "Field Is Not Empty",
  "Name": "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.

Code Block
{
  "Type": "Field Is Not Equal",
  "Name": "Regulation",
  "Value": "GxP",
  "Ignore Case": true
}

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.

  • ValueValues: The value 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.

Code Block
{
  "Type": "Field Is Not One Of",
  "Name": "Regulation",
  "Values": ["GxP", "SOX", "SOX & GxP"],
  "Ignore Case": true
}

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.

  • ValueValues: The value 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 behaviour when this property is omitted. (i.e. Comparisons are case-sensitive by default.)

Evaluation

Constraint Type: Fields Are Required

Determines whether the specified field contains a value.

Required Properties

  • Type: Value must be Fields Are Required

  • Name: The name of the field to evaluate.

Optional Properties

...

  • 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.

Code Block
{
  "Type": "Field Is One Of",
  "Name": "Type",
  "Values": ["Configuration", "System", "Acceptance"],
  "Ignore Case": true
}