Table of Contents | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
orField 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
orNo
; 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
orField 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
orNo
; 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
orNo
; 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
orNo
; 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
} |