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 |