...
Info | ||
---|---|---|
| ||
|
image | ||||
---|---|---|---|---|
| ||||
Info | ||
---|---|---|
| ||
|
image | ||||
---|---|---|---|---|
| ||||
image | ||||
---|---|---|---|---|
| ||||
image | ||||
---|---|---|---|---|
| ||||
image | ||||
---|---|---|---|---|
| ||||
Condition Type | Description |
---|---|
Equal To | Every time the field name's value matches the field value, this condition is true. |
Greater Than or Equal To | Every time the field name's value is greater than or equal to the field value, this condition is true. |
Greater Than | Every time the field name's value is greater than the field value, this condition is true. |
Less Than or Equal To | Every time the field name's value is less than or equal to the field value, this condition is true. |
Less Than | Every time the field name's value is less than the field value, this condition is true. |
Not Equal To | Every time the field name's value is not equal to the field value, this condition is true. |
Info | ||
---|---|---|
| ||
|
Determinant Condition Type | Value Sent in WMS File Task Field | Value Configured in Determinant | Functional Outcome |
---|---|---|---|
Equal To | numeric | numeric | both values are treated as numeric and evaluated accordingly |
| numeric | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated |
| varchar | numeric | DetFieldValue is converted to varchar and then expression is evaluated |
| varchar | varchar | Expression is evaluated |
| numeric | no value | both values are converted to varchar and then expression is evaluated as FALSE |
| varchar | no value | DetFieldValue is converted to varchar and then expression is evaluated as FALSE |
| no value | numeric | both values are converted to varchar and then expression is evaluated as FALSE |
| no value | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated as FALSE |
| no value | no value | both values are converted to varchar and then expression is evaluated as TRUE |
Not Equal To | numeric | numeric | both values are treated as numeric and evaluated accordingly |
| numeric | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated |
| varchar | numeric | DetFieldValue is converted to varchar and then expression is evaluated |
| varchar | varchar | Expression is evaluated |
| numeric | no value | both values are converted to varchar and then expression is evaluated as TRUE |
| varchar | no value | DetFieldValue is converted to varchar and then expression is evaluated as TRUE |
| no value | numeric | both values are converted to varchar and then expression is evaluated as TRUE |
| no value | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated as TRUE |
| no value | no value | both values are converted to varchar and then expression is evaluated as FALSE |
Less Than | numeric | numeric | both values are treated as numeric and evaluated accordingly |
| numeric | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated |
| varchar | numeric | DetFieldValue is converted to varchar and then expression is evaluated |
| varchar | varchar | Expression is evaluated |
| numeric | no value | always evaluated as FALSE |
| varchar | no value | always evaluated as FALSE |
| no value | numeric | always evaluated as FALSE, forced (would be TRUE) |
| no value | varchar | always evaluated as FALSE, forced (would be TRUE) |
| no value | no value | always evaluated as FALSE |
Less Than or Equal To | numeric | numeric | both values are treated as numeric and evaluated accordingly |
| numeric | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated |
| varchar | numeric | DetFieldValue is converted to varchar and then expression is evaluated |
| varchar | varchar | Expression is evaluated |
| numeric | no value | always evaluated as FALSE |
| varchar | no value | always evaluated as FALSE |
| no value | numeric | always evaluated as FALSE, forced (would be TRUE) |
| no value | varchar | always evaluated as FALSE, forced (would be TRUE) |
| no value | no value | always evaluated as FALSE |
Greater Than | numeric | numeric | both values are treated as numeric and evaluated accordingly |
| numeric | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated |
| varchar | numeric | DetFieldValue is converted to varchar and then expression is evaluated |
| varchar | varchar | Expression is evaluated |
| numeric | no value | always evaluated as TRUE |
| varchar | no value | always evaluated as TRUE |
| no value | numeric | always evaluated as FALSE |
| no value | varchar | always evaluated as FALSE |
| no value | no value | always evaluated as FALSE |
Greater Than or Equal To | numeric | numeric | both values are treated as numeric and evaluated accordingly |
| numeric | varchar | WMSFileFieldValue is converted to varchar and then expression is evaluated |
| varchar | numeric | DetFieldValue is converted to varchar and then expression is evaluated |
| varchar | varchar | Expression is evaluated |
| numeric | no value | always evaluated as TRUE |
| varchar | no value | always evaluated as TRUE |
| no value | numeric | always evaluated as FALSE |
| no value | varchar | always evaluated as FALSE |
| no value | no value | both values are converted to varchar and then expression is evaluated as TRUE |
ON CHANGE | Current TaskValue | Next TaskValue | Same logic as EQUAL TO, but comparing the field within the same assignment |
Info | ||
---|---|---|
| ||
|
...