iConsole User Guide › Searching for Events › Customize a Search › Useful Customizations › Wildcards

Wildcards

Note: All search fields that require text input support ? and * wildcards.

Supported wildcards

CA DataMinder supports the familiar * and ? wildcards. It also supports % and _ (underscore) wildcards, as used in SQL database queries.

When defining a search, you can use these wildcards in any field that requires text input.  In these fields, you can substitute % or * for zero or more characters; you can substitute _ or ? for a single character.

Automatic wildcards

When you enter any text in a search filter, CA DataMinder adds leading and trailing % wildcards automatically when you enter a text value. For example, CA DataMinder interprets:

• rimm as equivalent to %rimm%.

  This example filters the search to only include users such as spencerrimmel.

• ma as equivalent to %ma%.

  This example filters the search to only include user groups such as 'Management' or 'Direct Marketing'.

Manual wildcards

You can manually enter % or * and _ or ? as internal wildcards within any text string in any search filter. For example:

• spen%rim or spen*rim returns a range of matching names, such as spencerrimmel or spenserrimel.
• spen_errimmel or spen?errimmel limits the possible matches to a more narrow range of names such as spencerrimmel or spenserrimmel. It does not return names such as spenserrimel.

Literal wildcards

To search for literal % or * and _ or ?  wildcard characters, prefix them with a backslash. For example:

• 25\% detects "25%"
• 24\*7 detects "24*7"
• my\_file.xls detects "my_file.xls"
• What next\? detects "What next?"