My Oracle Support Banner

Oracle Taleo Enterprise Edition: How to Filter for a Specific Value without Excluding NULL Values (Doc ID 2416727.1)

Last updated on OCTOBER 12, 2023

Applies to:

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


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.



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

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:




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.