Skip Navigation
Expand
Creating join filters in Analytics
Answer ID 8969   |   Last Review Date 11/18/2018

How do I create an outer join filter in a report?

Environment

Analytics
Oracle Service Cloud

Resolution

When you create an outer join, you can add join filters to filter the data returned from the secondary table without filtering the data from the primary table.

To create a join filter within a report that utilizes an outer join, use the steps below:

  1. Open the report for editing.
  2. On the Home tab on the ribbon, click Tables
  3. In the pop-up window, click the secondary table
  4. Click Join Filters to expand the filter window and click Add Filter
  5. In the Add Filter window, define the name, expression, operator, value type, and value for the join filter
  6. Click OK on both pop-up windows
  7. Save the report

Note: Join filters cannot be used as a run-time filter.

Image


For additional information, refer to the 'Create outer join filter' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.

See also:

Answer ID 1839: Types of table joins used with reports

Answer ID 5612: Best practices for table joins in Analytics

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.