Filter
Top Products
C
OLLECTING
D
ATA
WITH
L
OG
M
ANAGER
7-8
Filter Formula syntax
The filter formula can be a simple or complex expression.
Syntax for Simple Expressions
A simple expression conforms to the following syntax:
Variable Relation Value
Variable - Legal variables include:
VALUE -- Value of the data
DATE -- Date the data arrives
TIME -- Time the data arrives
Relation - Legal relations include:
> -- Greater than
< -- Less than
>= -- Greater than or Equal to
<= -- Less than or Equal to
== -- Equal
!= -- Unequal
Value - Legal values include:
<INTEGER VALUE> -- An unsigned integer, 0 ~ 4 bytes long.
<yyyymmdd> -- Eight digits representing a date, where yyyy stands for the year, mm the month
and dd the day
<hhmmss> -- Six digits representing time in 24-hour format, where hh stands for hour, mm
minutes and ss seconds
Syntax for Complex Expressions
A complex expression combines several simple expressions using logical operators. Each expression must be
enclosed in parentheses. The syntax for a complex expression follows:
(Simple Expression) Logical_Operator (Simple Expression)
As described in the previous section a simple expressions should have three basic elements, namely, a Variable,
Relation, and Value. Legal values for each element are described under the syntax for simple expressions.