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