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.