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, 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
  • 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

      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.


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.