Special Characters

The use of special characters within the text boxes for a Filter enables the use of complex filter strings.

All Fields

The following characters are supported:

Special Characters	Description
Exclamation mark (!)	Not equal to
Percent (%)	Fuzzy matching (equivalent to a SQL LIKE %)
Underscore (_)	Fuzzy matching of a single character
Comma (,)	Can be used to search for multiple values at the same time

Device Fields

In addition to the special characters above, the following characters are supported when searching using a device based field (Extension, Agent, Trunk, Hunt Group):

Special Characters	Description
Plus sign (+)	Greater than or equal (e.g. 1000+ for extensions greater than or equal to 1000)
Hyphen (-)	Delimits a range of values to match (e.g. 1000-2000 for all extensions between 1000 and 2000 inclusive) or less than or equal to (e.g. -1000 for extensions less than or equal to 1000)

The example below shows what would be matched when entering combining multiple special characters using a comma:

1000-1005,!1003,1040,18%5,2000+

Matching endpoints: 1000, 1001, 1002, 1004, 1005, 1040, any that start with 18 and end with a 5, any with a value greater or equal to 2000.

Device numbers are stored as text so when using greater than or less than, it is compared on an alphabetic level not a numeric level