Using Optimized Filtering Fields
Optimized fields end with the words Code (for picklists) or UTC (Coordinated Universal Time) for date-time fields. Using the optimized field in the filter improves report performance.
Code Fields in Filters
Code fields store picklist values in language independent code (LIC) for multilanguage picklists. In Oracle CRM On Demand, you manage multiple languages by using language independent codes and individual entries for each language. For example, a status field might be implemented as follows for the language value with a status of Active.
To filter active accounts, you create a filter for the Status Code field (the optimized version of the Status field) and for the LIC value (in this case, Active). No matter which language you use, querying for the LIC value improves report performance because an extra translation step is not required to query other languages.
Displaying the LIC Values for a Picklist
To display the LIC values for a picklist, use the following procedure.
To display the LIC values for a picklist
UTC Fields in Filters
When you use UTC fields, they are not converted to company or user time zones and so they improve report performance. Performance is further improved when the date-time fields are indexed in the database. You can suppress these fields in your reports and use the fields that have adjusted time zones instead.
|Published 5/4/2012||Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.|