The table below shows the operators that can be used in complex event processing language expressions. The operator priority sequence is the same as Java standard.
Type | Operator | Explanation |
|---|---|---|
Arithmetic | +, - | Monadic operators indicating positive and negative values. Dyadic operators for performing addition and subtraction. |
*, / | Dyadic operators for performing multiplication and division | |
% | Dyadic operator for performing modulo (division remainder) operation | |
Logical | NOT | Negation of a logical value |
OR | Logical conjunction of two logical values | |
AND | Logical disjunction of two logical values | |
Comparison | =, !=, <, >, <=, >= | Comparison of two values |
Join | || | Joining of two character strings |
Binary | & | AND operation for each bit |
| | OR operation for each bit | |
^ | Exclusive logical disjunction (XOR) operation for each bit |
In addition, the keywords shown in the table below can be used in complex event processing language expressions.
Keyword | Syntax | Explanation |
|---|---|---|
IN | evaluationExpression [not] in (expression [,expression] [, ...] ) | Returns TRUE if the value of the evaluationExpression is the same as any of the expression values within parentheses. If NOT is present, the negated value (if TRUE, FALSE is returned, and if FALSE, TRUE is returned) is returned. |
evaluationExpression [not] in ([ | () lowerLimitValue : upperLimitValue () | ]) | Returns TRUE if the value of the evaluationExpression is within the lowerLimitValue and upperLimitValue range. If square brackets, "[" and "]", are used, the lowerLimitValue and the upperLimitValue are included in the range. If parentheses, "(" and ")", are used, the lowerLimitValue and the upperLimitValue are not included. If NOT is present, the negated value is returned. | |
BETWEEN | evaluationExpression [not] between startExpression and endExpression | Returns TRUE if the value of the evaluationExpression is within the startExpression and endExpression range. The startExpression and endExpression values are both included in the range. If NOT is present, the negated value is returned. |
LIKE | evaluationExpression [not] like patternRepresentation [escape character] | Provides the SQL standard pattern matching function. Returns TRUE if the character string value of the evaluationExpression matches the pattern shown at patternRepresentation. If NOT is present, the negated value is returned. In the patternRepresentation, an underscore (_) indicates any single character, and the percent symbol (%) indicates any character string (includes 0 characters). The underscore (_) and the percent symbol (%) can be used as ordinary characters in a patternRepresentation by preceding them with the character specified as the ESCAPE. |
REGEXP | evaluationExpression [not] regexp patternRepresentation | The same regular expressions as those implemented by the Java java.util.regex package are used in the patternRepresentation to perform evaluationExpression pattern matching. |
ANY, SOME | expression operator any (expression [,expression] [, ...] ) expression operator some (expression [,expression] [, ...] ) | Uses operator to compare the left-side expression against all the expression values within parentheses on the right side, and returns TRUE if the result of any of the comparisons is TRUE. SOME and ANY are the same. |
ALL | expression operator all (expression [,expression] [, ...] ) | Uses operator to compare the left-side expression against all the expression values within parentheses on the right side, and returns TRUE if the result of all of the comparisons is TRUE. |
