How Siebel CRM Handles Wildcards

To include a wildcard in a search string (for example, "ABC*" or "*ABC?"), you can explicitly include it. Siebel CRM can also append a trailing wildcard (*) if all of the following conditions are true:

• The search string does not contain any wildcard. For example: "ABC".

• The = (equal) sign does not precede the search string.

• The AutomaticTrailingWildcards parameter in the InfraUIFramework section of the application CFG file is set to TRUE or does not exist. The uagent.cfg file is an example of an application CFG file. If the parameter is:

  • TRUE. Siebel CRM automatically creates a trailing wildcard or adds a LIKE predicate. If you use a script, and if this script creates a query, then Siebel CRM adds a LIKE statement to the SQL that this script creates.

  • FALSE or does not exist. Siebel CRM does not automatically create a trailing wildcard or add a LIKE predicate. It typically sets this parameter to FALSE to avoid using the Use Literals For Like user property.

However, note that wildcards are handled differently when you perform a wildcard search in a popup window using the filter search fields and using the Query button as follows:

• Filter search fields. In this case, searching for *Ave returns all records containing *Ave, for example, as follows:

  Eight Ave Gourmet Market
  Fourth Ave. Grocery
  Gourmet Market 5th Ave

  In this instance, a trailing wildcard (*) is appended to the search string.

• Query button. In this case, searching for *Ave returns only records ending with *Ave as follows:

  Gourmet Market 5th Ave

  In this instance, a trailing wildcard (*) is not appended to the search string.