The following operators are valid for use in filter statements:
Operator: |
Alternative Operator: |
Meaning: |
= |
.EQ. |
equal to |
<> |
.NEQ. |
not equal to |
>= |
.GTE. |
greater than or equal to |
<= |
.LTE. |
less than or equal to |
| |
.OR. |
Or |
& |
.AND. |
And |
|
.LIKE. |
Like - string comparison with wild cards. Uses % as string wildcard |
- |
Minus |
|
+ |
Plus |
|
* |
Multiply |
|
/ |
Divide |
|
# |
Xor |
The alternative operators result in equivilant expressions as the primary operator. They were added to the filter parser to make expressions easier to read. Primary and alternative operators may be mixed and matched within or across expressions.
Examples:
(( TypeOfCollision = TypeOfCollision.RearEnd ) | ( Type of Collision = TypeOfCollision.SideSwipe)) & (Injuries >= 1)
is the same as
(( TypeOfCollision .EQ. TypeOfCollision.RearEnd ) .OR. ( Type of Collision .EQ. TypeOfCollision.SideSwipe)) .AND. (Injuries .GTE. 1)
