In this article
Search Tips
You can filter Call Management lists to find a subset of calls by looking for specific properties. Each column has a field below the column heading; enter values in these fields to filter the current list as ‘Quick Filters’.
The following methods can be used to apply more specific filters:
Use the asterisk symbol * as a wildcard where you don’t need to match the entire string value. For example entering *321 in the telephone number column will return a list of all records where the number contains 321.
To apply an exact match filter, enclose the search string in double quotes. To filter on empty values, enter two adjacent double quotes “”.
Search for exact match string values using double quotes – e.g. “1” will return matches of exactly ‘1’ but not any string starting with a 1 like 11, 123, 1201 etc.
In situations where it is not possible to achieve the desired filter using Quick Filters it is also possible to set up Advanced Filters (Advanced Filters can be used in combination with Quick Filters). Click here to learn more about Advanced Filters.
Filter Using Multiple Values
Use comma-separated values to filter with a logical OR comparison.
Example 1
Active,Pending
Returns: All records where values include strings which start with either ‘Active’ OR ‘Pending’.
Negation
Use ! to exclude specific values or patterns.
Example 2
!Active
Returns: All records where value does NOT include a string that starts with ‘Active’.
Example 3
!"Pending"
Returns: All records where value does NOT include ‘Pending’ string with an exact match.
Filters using a Combination of Positive and Negative Conditions
Positive conditions are combined with OR.
Negative conditions are combined with AND NOT.
Example 4
Active,!*Pending
Returns: All records where value includes strings which start with ‘Active’ AND NOT contain ‘Pending’.
Whitespace and * Wildcard Handling
Trim spaces around values and keep wildcard support.
Example 5
*Active , Pen*ding
Returns: All records which contain ‘Active’ OR are started from ‘Pen’ and contain ‘ding’ strings.
Combining of Positive Conditions
To combine all positive conditions, group them first and then add negative conditions.
Example 6
A, !B, C, !D, E
Returns: All records where values include strings starting with A, C or E AND NOT B or D.