Operators Supported in Filters

Table 18 shows the operators that are supported in the ActiveSpaces filters:

Operators for 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