Print      Open PDF Version of Online Help

Getting Started > Working with Records > Finding Records > About Filter Values

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, follow these guidelines:

• Use commas to separate values in a list of values with any of the following conditions:
  • Contains all values
  • Contains at least one value
  • Contains none of the values
  • Equals any
• Do not use a comma within a value with any of the following conditions:
  • Contains all values
  • Contains at least one value
  • Contains none of the values
  • Equals any

    Commas are treated as separators in the list of values, and therefore cannot be used within the values themselves. If the values for the filter contain commas, use a combination of other conditions to create the filter that you want.

• For numeric values, do not use commas to indicate values in thousands.
• You can use partial words with the Contains at least one value condition. However, using partial words with the other conditions does not retrieve the records that you want.

  NOTE: This behavior applies to filtered lists that use the Contains at least one value condition and not to other areas in Oracle CRM On Demand.

• For dates, enter them in the format that 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.