Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

How to make LEFT OUTER JOIN in BO Reporting in TALEO

edited Dec 13, 2022 6:58AM in Taleo Enterprise

Content

Hi everyone,

I have a question on reporting. I am not sure if anyone has ever done any LEFT OUTER JOIN in Business Object yet!


Please help if you can!

I need to do a LEFT OUTER JOIN in my reports and I can't find any solution for it.


What I need is a report containing the following information:
- Requisition that are OPEN  with description and show lines where candidate is hired. When there is a candidate hired or offered in the requisition, there should be a line showing his name and ID.
- In the case, when requisition that has no Candidate hired or offered on them but there are still candidate on different selection steps, then ONLY the Requisition information should show on the report, but information on the candidate should be blank, and there should only be one line for that requisition!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!