Print      Open PDF Version of Online Help


Previous Topic

Next Topic

About Filter Values

When you search for records, depending on the filter condition that you choose, you must enter a filter value.

When entering filter values for a search, make sure you follow these rules:

  • For numeric values, use commas to separate values, and not to indicate values in thousands.
  • You can use partial words with the condition Contains At Least One Value, but using partial words with the other conditions does not retrieve the records you want.

    NOTE: This behavior applies to filtered lists that use the condition Contains At Least One Value, and not to other areas in Siebel CRM On Demand .

  • For dates, enter them in the format your company uses but include four digits for the year, such as 2003.
  • For currency, omit commas and symbols, such as the dollar sign ($).

Using Wildcards with Filter Values

You can use the wildcard characters (* and ?) in searches of text and phone fields only where the filter condition is Begins with.

CAUTION: Using the asterisk character (*) might result in slow performance if used with large amounts of data.

You can use wildcards in the following types of search:

  • The Search Criteria section in Advanced Search
  • The Search Criteria section in the Create List and Refine List pages
  • Alpha Search on List pages
  • Quick Search on List pages
  • The Search section in the Action bar

For telephone number fields, you can, for example, search for all telephone numbers of a certain area code. To do this, click the phone icon, and in the Phone Number pop-up, enter the area code and then the asterisk (*) wildcard in the Local Number field.


Published 05/11/2007