You can use operators to filter the data that appears in reports.
This table describes the operators that you can use to filter report data:
Operator | Description | Values that you can use with the operation | Example |
|---|---|---|---|
= | Equal to |
| =Oracle Database |
< | Less than | Numeric values | <100 |
> | Greater than | Numeric values | >20 |
<= | Less than or equal to | Numeric values | <=54 |
>= | Greater than or equal to | Numeric values | >=99 |
&& | And |
|
|
|| | Or |
|
|
!= | Not equal to |
|
|
begins: | Text string begins with | Alphabetic values | begins:EDGE |
ends: | Text string ends with | Alphabetic values | ends:_DRIVE |
equals: | Text string equals | Alphabetic values | equals:CommCell |
notequals: | Text string does not equal | Alphabetic values | notequals:FileSystem |
contains: | Text string contains This is the default behavior when you enter text. | Alphabetic values | contains:arc |
notcontains: | Text string does not contain | Alphabetic values | notcontains:ex |
s | Seconds | Numeric values | 60s |
m | Minutes | Numeric values | 60m |
h | Hours | Numeric values | 12h |
d | Days | Numeric values | 30d |
w | Weeks | Numeric values | 4w |
M | Months | Numeric values | 3M |
y | Years | Numeric values | 1y |