Wild Cards

General Knowledge
DSS auto-complete fields new support wildcards.   Searches are case-insensitive and the supported wildcards are as follows:
 
Wildcard character
Description
Examples
%
Any string of zero or more characters.
·       %999% will find all entries with 999 in the field
·       999% will find all entries starting with 999
·       %999 will find all entries ending with 999
*
Any string of zero or more characters (same as %)
·       *999* will find all entries with 999 in the field
·       999* will find all entries starting with 999
·       *999 will find all entries ending with 999
_ (underscore)
Any single character.
·       9900_0C will match 990010C, 990020C, 990030C , 9900420C, etc
[ ]
Any single character within the specified range ([a-f]) or set ([abcdef]).
·       990010[CJ] will match 990010C and 990010J
·        9900*[CJ]  will match all entries starting with 9900 and ending in either C or J, such as 990009C, 990018J
[^]
Any single character not within the specified range ([^a-f]) or set ([^abcdef]).
·       990090[^J] will seven character entries starting with 990090 where the final character is not J, such as 990090C
 
 
Here’s how it works:
 
Case: No wildcards used
If the user does not use a wildcard an implicit “*” is appended to the search string.  This means the autocomplete will find anything that starts with the text provided.  Some filters, like colour and style, will try and match both the code (ex “990009C”) and the description (ex “Classic Tennis”).  The below examples illustrate this.
 
 
 
Case: Wildcards used
If the user specifies either wildcards * or %, the pattern is taken as given; no implicit “*” is appended.  In the example below, the pattern “*army*camo*” returns any colours where the word “army” appears followed by the word “camo”.
 
 
In the following example, the terminating * is removed from the pattern and no results are returned.  This is because there are no colours containing the word “army” and ending with “camo”
 
 
In this final example, the pattern was altered to drop the requirement for “army” resulting in only colours ending in “camo” being returned.
 
Article ID: 10, , Modified: 1/13/2016 at 10:49 AM

Was this article helpful?

Share this article