Skip Navigation
Filters can reduce the data set even when set to "All"
Answer ID 9060   |   Last Review Date 12/18/2018

When I add a filter set to "All" why are there fewer results than if I have no filter? 


Analytics / Reports
Oracle B2C Service, All versions


When a filter is added to a report, the number of results returned is reduced, even when the filter is set to "All."


When a filter is added on a table other than that which is being displayed, an automatic INNER JOIN is added to the table, which will exclude results with a NULL value on the filtered column. In other words, if the column filtered contains NULL values, they will not be displayed by the table.

For example: If a report on incidents contains a filter on queues.queue_id, if any incidents are not assigned to a queue, they will not be included in the results.

To resolve this issue change the table join type to an OUTER JOIN. To do this, open the report for edit and follow these steps:

  1. On the Ribbon --> in the Home tab --> in the Data Set area --> select Tables.
  2. Select the table being used for the filter (queues).
  3. Change Join Type from Inner to Outer.

Home ribbon, Data Set section, click the Tables button

Once two or more tables are joined, the Join Type can be changed between Inner and Outer in the Data Set window.

To learn more about join types see Answer 1839: Types of table joins used with reports.

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