My Oracle Support Banner

How To: Query for "Both" Rather Than "One or the Other" (Doc ID 2135088.1)

Last updated on JANUARY 04, 2019

Applies to:

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

Goal

Question:

I have an analysis/report where the results need to include records that have BOTH one value AND another value.  For example, I need to see all candidates who have completed both Disqualification Question 1 AND Disqualification Question 2.

  • When I use two filters with is equal to / is in, I get "No Results". 
  • When I set a single filter to is equal to / is in and list both values, the results give me candidates who have the first value OR the second value.

Is there a way to filter for both values in OBI?


 

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!


In this Document
Goal
Solution
References

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