Logical Operators
The usual logical operators include AND, OR, and NOT. Their operation results can be TRUE, FALSE, or NULL. NULL indicates unknown. Their priorities are NOT > AND > OR.
Table 1 lists the calculation rules, where a and b represent logical expressions.
a |
b |
a AND b Result |
a OR b Result |
NOT a Result |
---|---|---|---|---|
TRUE |
TRUE |
TRUE |
TRUE |
FALSE |
TRUE |
FALSE |
FALSE |
TRUE |
FALSE |
TRUE |
NULL |
NULL |
TRUE |
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
TRUE |
FALSE |
NULL |
FALSE |
NULL |
TRUE |
NULL |
NULL |
NULL |
NULL |
NULL |

- The operators AND and OR are commutative, that is, you can switch the left and right operand without affecting the result.
- Operations on XML data are not supported.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot