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.
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