These settings allow you to define a filtering condition which will be used to filter the data associated with the selected browser view.
A filter consists of:
-
Field name
-
Operator or function
-
Value
-
Logical expressions: And / Or (for complex filter conditions)
-
A complex filter condition may take longer to retrieve your data. For this reason, performing an OR operation is more time-consuming than performing an AND operation.
The following table lists the built-in operators and functions available to you when defining the filter settings:
|
Operator/Function |
Description |
Example |
|
= |
Equal to |
Manufacturer = "Shell" |
|
> |
Greater than |
Tag Number > 101 |
|
< |
Less than |
Process Function Name < 'P' |
|
>= |
Greater or equal to |
Velocity >= 10 |
|
<= |
Less than or equal to |
Low Alarm <= 30 |
|
<> |
Not equal to |
Loop Suffix <> AA |
|
BETWEEN |
Select an alphanumeric value that is between the stated expression. |
Price between 150 and 250 |
|
LIKE (value) |
Select a similar value that is similar to the one in the '[value]'field. |
Tag Number LIKE '%AA%' |
|
IS NULL |
Contains an undefined value |
Service IS NULL |
|
IS NOT NULL |
Not equal to NULL |
Loop Number IS NOT NULL |
|
AND |
Include the following expression in the filter combination. |
|
|
OR |
Accept either the previous or the following expression in the filter expression. |