My Oracle Support Banner

How To: Filter for a Specific Value without Excluding NULL Values (Doc ID 2416727.1)

Last updated on JULY 24, 2018

Applies to:

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

Goal

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:

A Requisition Flex Field (UDF) has possible values of:

  • California
  • New Mexico
  • Utah
  • NULL

If a filter is applied to exclude New Mexico, this will also eliminate NULL because the SQL is checking for whether the value equals New Mexico in order to eliminate it from the results.

Results without any Filters:

Results with Filter to Exclude New Mexico:

 

 

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!


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