You can use certain special characters to perform "wildcard-search" using the following combinations:
The % character represents a string of characters at the position it is used. The system applies this character by default for phone number fields. Search pattern variations denoted by * can be resource intensive and can result in long search execution.
If only the beginning of a field value is known, the remaining unknown string can be replaced with the "%" character. For example specifying 414% in the extension search field will list all conversations where the extension number begins with 414.
* If only the ending of the value to be found is known, the remaining unknown string can be replaced with the "%" character. For example specifying %414 will list all conversations where the field value ends with 414.
* If only the internal section of the field value is known, the preceding and trailing sections can be replaced with the "%" character. For example typing %414% will list all conversations where the field value contains 414 after the first digit and before the last digit.
|_||If only the number of digits are known in the field, but one or more digits are uncertain, replace the unknown digit with "_" (underscore) character. E.g. typing 4143_69 will list all conversations containing this pattern (the "_" can be any character, excluding empty character).|
If the number of digits in the field are known, but one or more digits are uncertain and the possible values are known, the unknown digit(s) can be replaced with "" or "[0-9]" character(s). E.g. typing 4143[4-8]69 or 414369 will list all conversations containing this number (the "[4-8]" or "" can be any number between 4 and 8).
None of the fields are case sensitive, so you can use either uppercase or lowercase letters. You can also combine the above mentioned special search patterns.
Example search pattern
|414[3-7]_6%||This will list all conversations that start with 414, the fourth number is one of 3, 4, 5, 6 or 7, the fifth number can be any character (excluding nothing or an empty character), the sixth number is 6, and after character 6 the number can contain anything (including nothing).|