Selecting filter options
The filter options available depend on whether the data type is numeric,
time, or string.
Case insensitive
Case Insensitive specifies that upper and lowercase values for a string item are treated equally. For example, case insensitive specifies that ABC and abc are equivalent.
Comparison operator
Comparison operators compare values with your item's filter From value. You select a comparison operator from the descriptions listed in the Filter Option dialog, and the operator is automatically inserted into the data extraction query. The default setting is None.
| Description | Operator | Mode |
|---|---|---|
| None | Default | |
| Display all values | <ALL> | Default |
| Is greater than | > | Default |
| Is greater than or equal to | >= | Default |
| Is less than | < | Default |
| Is less than or equal to | <= | Default |
| Is not equal to | <> | Default |
| Is Like | *=% | Default |
| Not Like | *!% | Default |
| Is in list | << | Combination |
| Is not in list | <<! | Default |
| Is Null | <IS NULL> | Default |
| Not Null | <IS NOT NULL> | Default |
Segment
Segment extracts a sub-section from a string. It contains these details:
- Offset: The number of characters prior to the start of the segment string.
- Length: The number of characters in the segment string.
For example, specify Offset as 14, and Length as 1, to extract the string c from the string debit/credit: c 19/03/2012.
Mode
Mode contains these details:
- Default: To apply pattern matching or comparison operators in the Data Filter Item criteria.
- Combination: To filter on contiguous and non-contiguous ranges, using a combination of ranges (.. 2 dots) and filter values separated by comma ( , ) syntax. For example, specify <<10000..12000,19000,22000 to filter on account codes 10000,11000,12000,19000 and 22000.
- Literal: To use reserved characters such as %, < and > literally in a search.