Oracle Taleo Enterprise Edition: How to Filter for a Specific Value without Excluding NULL Values
(Doc ID 2416727.1)
Last updated on SEPTEMBER 17, 2022
Applies to:Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 19A and later
Information in this document applies to any platform.
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:
- United States
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