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