![]() |
|
About Filter ConditionsFor searches, different filter conditions are available depending on the data type of the search field, as shown in the following table. NOTE: In some cases, a search does not return records that have a null value in a field that you use in the criteria for a search or list filter. For example, if you search for opportunities that have a status that is not equal to Won, then opportunities that have a null status are not returned. If you want your search to return records that have a null value in a field, then include an Is NULL condition for that field. In the example used earlier, if you want your search to return opportunities that have a null status as well as opportunities that have a status other than Won, then include an Is Null condition for the status field in the search criteria, as well as the condition to find records that have a status that is not equal to Won.
About Filter Conditions for Picklist FieldsFor the Between, Greater than, and Less than conditions for picklist fields, Oracle CRM On Demand searches the language independent codes (LICs) of the picklist values and not the picklist values themselves, to find the records that meet the filter criterion that you specify. So, your search results include all records in which the LIC of the picklist value meets the criterion, even if the picklist value itself does not. Similarly, your search results do not include records in which the picklist value meets the criterion, but the LIC of the picklist value does not. For example, assume that your administrator creates a picklist value called Beta. The LIC for the new picklist value is the same as the picklist value by default. So, a search with the following filter returns records in which the picklist value is Beta: Between Alpha, Gamma However, if your administrator later changes the picklist value from Beta to Not Beta, then the LIC for the picklist value does not change. So, if you search for records using the filter shown above, then your search results include all records in which the picklist value is Not Beta, because the LIC for the picklist value is still Beta. However, if you search for records using the following filter, then your search results do not include records in which the picklist value is Not Beta, because the LIC for the picklist value does not meet the specified criterion: Between Gamma, Zeta Similarly, if you search for a translated version of a picklist value, then your search results include all records in which the LIC of the picklist value meets the specified criterion, even if the translated picklist value does not. For conditions for picklist fields other than the Between, Greater than, and Less than conditions, Oracle CRM On Demand searches the picklist values themselves and not the LICs, to find the records that meet the filter criterion that you specify. Equals Any Filter ConditionThe Equals any filter condition searches for records that exactly match any one of the specified values. This filter condition is supported only for picklist fields for which the Lookup icon (magnifying glass) is available in record Detail pages and Edit pages. It is not supported for picklist fields for which a drop-down list of values is available in record Detail pages and Edit pages. For this type of picklist field, use the Contains all values filter condition to search for records that exactly match any one of the specified values. In addition, the Equals any filter condition is not supported for multi-select picklist fields. For information about searching on multi-select picklist fields, see About Searching on Multi-Select Picklists. How Filter Conditions Are UsedThe following table shows how various filter conditions and operators are used:
|
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |