# Operators for Report Filters

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 | Alphabetic values Numeric values | =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 | Alphabetic values Numeric values | SAP&&for 3&&1
|| | Or | Alphabetic values Numeric values | DB2||Oracle 2||3
!= | Not equal to | Alphabetic values Numeric values | !=Completed !=0
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

×

Loading...