Operators Supported in Filters
Table 18 shows the operators that are supported in the ActiveSpaces filters:
Operator | Meaning |
---|---|
>, >= |
greater than |
NOT or ! or <> |
not |
* |
multiply |
= |
equal |
!= |
not equal |
ABS |
absolute value |
MOD or % |
modulo, as in ( MOD (x,y) or x % y) |
NOT BETWEEN |
not between |
BETWEEN |
between |
|| |
string concatenation |
NOT LIKE |
not like (regex) |
LIKE |
like (regex) |
<, <= |
less than |
+ |
addition |
OR |
or |
- |
subtraction |
AND |
and |
IN |
range, as in “age in (1,3,5,7,11)" |
NULL |
does not exist |
NOT NULL |
exists |
IS |
only used with NULL or NOT NULL, as in “x IS NULL" or "x IS NOT NULL" |
NOR |
nor, as in “age NOT 30 NOR 40“ |
/* .... |
comments |
// .... |
comments |
Copyright © TIBCO Software Inc. All Rights Reserved.