| Drucken PDF-Version der Onlinehilfe öffnen

#### 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 For all field types except picklist fields, do not use a comma within a value 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 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 picklist fields, you can use a value that contains a comma, provided that the comma is followed by a space. A comma that is followed by a space is not treated as a separator in the list of values. 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.

Veröffentlicht August 2022 | Copyright © 2005, 2022, Oracle und / oder verbundene Unternehmen. Legal Notices.