Application Basics > Common Functions > Using Wildcards when Searching
Using Wildcards when Searching
Wildcard functionality is enabled, usually during implementation, through the setting of two global setting values.
Global Setting
Description
Default Value
FILTERS_USE_WILDCARDS
This is a true/false setting.
• When set to True, the wildcard functionality is enabled.
• When set to False, the wildcard functionality is not enabled.
True
FILTERS_WILDCARD_CHAR
This is the character that represents the wildcard.
%
* 
The wildcard can be set to numeric, alphanumeric, and special characters other than %.
When the wildcard functionality is enabled, you can substitute the wildcard symbol for one or more characters when entering a value in a text box. The wildcard symbol can be entered at the beginning, middle, or end of the search string. For example::
Filter Value
Action
Result
%949
Filters all records with field values ending with 949
123949
949%
Filters all records with field values beginning with 949
9490949123
949
Filters all records with field values beginning with 949
* 
There is an automatic wildcard at the end of a search string. This means that if you search for 949, the values 949, 949678, and 9498 would be found, even though you did not enter a wildcard manually.
9490949123
9%49
Filters all records with field values beginning with 9 and ending with 49
9123499049
%949%
Filters all records with 949 in the middle of field values
79490123949123
Was this helpful?