My Oracle Support Banner

Webinar: Using JoinFieldValue to Improve Report Performance (Doc ID 1801404.1)

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.