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:

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

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