Loading...

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

This is the default behavior when you enter text.

Alphabetic values

equals:CommCell

notequals:

Text string does not equal

Alphabetic values

notequals:FileSystem

contains:

Text string contains

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

Last modified: 6/15/2018 6:48:37 PM