My Oracle Support Banner

OTAC/TEE: How to Filter for a Specific Value without Excluding NULL Values (Doc ID 2416727.1)

Last updated on JANUARY 17, 2020

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 19A and later
Information in this document applies to any platform.

Goal

Document Purpose:

This document will provide advice on how to prevent when a column is filtered to include or exclude specific value(s), this can cause NULL values to be automatically eliminated from the results.

 


Example:

The Country of Residence for specific candidates returns the following values:

  • Canada
  • China
  • Romania
  • United States
  • NULL

If a filter is applied to exclude China:

This eliminates NULL because the SQL is checking for whether the value equals China in order to eliminate it from the results. 

This requires a value to exist for the Country of Residence for that candidate record.

 


Results without Filters on the Country of Residence:

 

Results with a Filter on the Country of Residence to Exclude China:

 

 

Solution

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
Goal
Solution


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