Filter Examples

The following is a list of filter examples that are useful throughout the system, along with their criteria:

Filter

Item

Operator

Criteria 1

Criteria 2

Restrict the report to Fund 04 only

Fund Code

=

04

n/a

Exclude Fund 04

Fund Code

<>

04

n/a

Include Funds 03 and higher

Fund Code

>

02

n/a

Include Funds 03 and lower

Fund Code

<

04

n/a

Include Funds 02 and 03 only

Fund Code

Between

02

03

Exclude Funds 02 and 03 only

Fund Code

Not Between

02

03

GL Codes beginning with 5

GL Code

Like

5%

n/a

GL Codes not beginning with 5

GL Code

Not Like

5%

n/a

GL Codes beginning with 5, any number in second position, followed by 234

GL Code

Like

5_234

n/a

GL Codes not beginning with 5, any number in second position, followed by 234

GL Code

Not Like

5_234

n/a

Include GL Codes in this series

GL Code

In

11600, 21040, 47001

n/a

Exclude GL Codes in this series

GL Code

Not In

11600, 21040, 47001

n/a