| Operators and Operator IDs |
The following table lists the operators and their corresponding IDs.
|
Operator |
Operator ID |
|---|---|
|
OR |
1 |
|
AND |
2 |
|
> |
3 |
|
>= |
4 |
|
< |
5 |
|
<= |
6 |
|
contains |
7 |
|
= |
8 |
|
exists |
9 |
|
starts with |
10 |
|
NEAR |
11 |
|
<> |
12 |
|
contains near |
13 |
|
in |
14 |
|
on |
15 |
|
on or before |
16 |
|
on or after |
17 |
|
does not contain |
18 |
|
include subteams |
19 |
|
is null |
20 |
|
OR (in any row) |
103 |
|
AND (in any row) |
104 |
|
>(in any row) |
105 |
|
>= (in any row) |
106 |
|
< (in any row) |
107 |
|
<= (in any row) |
108 |
|
contains (in any row) |
109 |
|
= (in any row) |
110 |
|
starts with (in any row) |
111 |
|
<> (in any row) |
108 |
|
in (in any row) |
113 |
|
on (in any row) |
114 |
|
on or before (in any row) |
115 |
|
on or after (in any row) |
116 |
|
does not contain (in any row) |
117 |
|
is null (in any row) |
118 |
|
include subteams (in any row) |
119 |
|
ends with |
23 |
|
ends with (in any row) |
120 |