Service Studio 6.0 Help
Logical and Boolean Operators
In Service Studio you have the logical and boolean operators presented below.
Unary NOT
Performs the logical NOT operation.
Allowed Data Types
|
NOT |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
No |
No |
No |
Yes |
No |
No |
No |
AND
Performs the logical And.
Allowed Data Types
|
AND |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
Text |
No |
No |
No |
No |
No |
No |
No |
|
Integer |
No |
No |
No |
No |
No |
No |
No |
|
Decimal |
No |
No |
No |
No |
No |
No |
No |
|
Boolean |
No |
No |
No |
Yes |
No |
No |
No |
|
DateTime |
No |
No |
No |
No |
No |
No |
No |
|
Date |
No |
No |
No |
No |
No |
No |
No |
|
Time |
No |
No |
No |
No |
No |
No |
No |
OR
Performs the logical Or.
Allowed Data Types
|
OR |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
Text |
No |
No |
No |
No |
No |
No |
No |
|
Integer |
No |
No |
No |
No |
No |
No |
No |
|
Decimal |
No |
No |
No |
No |
No |
No |
No |
|
Boolean |
No |
No |
No |
Yes |
No |
No |
No |
|
DateTime |
No |
No |
No |
No |
No |
No |
No |
|
Date |
No |
No |
No |
No |
No |
No |
No |
|
Time |
No |
No |
No |
No |
No |
No |
No |
Comparison operators <, >, <=, >=
Common arithmetic operations. When one of the operand is Text, the other operand is cast to Text, and it performs the string comparison operation.
Allowed Data Types
|
<, >, <=, >= |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
Text |
Yes |
(a) |
(a) |
(a) |
(a) |
(a) |
(a) |
|
Integer |
(a) |
Yes |
Yes |
No |
No |
No |
No |
|
Decimal |
(a) |
Yes |
Yes |
No |
No |
No |
No |
|
Boolean |
(a) |
No |
No |
No |
No |
No |
No |
|
DateTime |
(a) |
No |
No |
No |
Yes |
No |
No |
|
Date |
(a) |
No |
No |
No |
No |
Yes |
No |
|
Time |
(a) |
No |
No |
No |
No |
No |
Yes |
(a) The non-text side is cast to Text and then compared.
Equality operators =, <>
Performs equality operations. When one of the operands is Text, the other operand is cast to Text, and it performs the string comparison operation.
Allowed Data Types
|
=, <> |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
Entity Rec. |
Integer Id. |
Text Id. |
|
Text |
Yes |
(a) |
(a) |
(a) |
(a) |
(a) |
(a) |
No |
No |
No |
|
Integer |
(a) |
Yes |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Decimal |
(a) |
Yes |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Boolean |
(a) |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
DateTime |
(a) |
No |
No |
No |
Yes |
Yes |
Yes |
No |
No |
No |
|
Date |
(a) |
No |
No |
No |
Yes |
Yes |
No |
No |
No |
No |
|
Time |
(a) |
No |
No |
No |
Yes |
No |
Yes |
No |
No |
No |
|
Entity Rec. |
No |
No |
No |
No |
No |
No |
No |
(b) |
No |
No |
|
Integer Id. |
No |
No |
No |
No |
No |
No |
No |
No |
(c) |
No |
|
Text Id. |
No |
No |
No |
No |
No |
No |
No |
No |
No |
(c) |
(a) The non-text side is cast to Text and then compared.
(b) Checks for the equality of structure first and, then, of attribute values.
(c) Identifiers of different entities can be compared but a warning is issued.