Last updated on OCTOBER 31, 2016
Applies to:Oracle CRM On Demand - Version 031CS and later
Information in this document applies to any platform.
Role: Reports Developer Language: English Length: 3 minutes
Expert: Bob Bray, Principal Product Manager for CRM On Demand.
Challenge: Getting lists and reports to perform well when cross-object filtering is required on a non-indexed field. Bob Bray uses the example of needing to filter on user division (from the User object) in an Opportunity History report.
Solution: Bob shows how you can use default field value and workflow features to bring the user division data into an indexed field on the Opportunity object. This allows you to follow the best practice of filtering on indexed fields for the best list and report performance.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms