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

Help with OBI IF formula

Accepted answer
52
Views
3
Comments
edited May 17, 2017 2:23PM in Reporting and Analytics Taleo Enterprise 3 comments

Summary

Issue: OBI does not have the referrer candidate ID and need help writing SQL formula

Content

We are having an issue where OBI does not have an object for the referrer candidate ID like it did in BO.  We will need to write a formula to get this information but we are not 100% sure how to write this formula...Anyone out there that could help??

What we need the formula to reflect:

In this situation, a CASE/WHEN formula will need to be used where when the "Candidate Referral"."Referrer Is Employee" is "Yes", then find "Candidate Referral"."Referrer Name" in the field "Candidate Identification"."Name" and return the "Candidate Identification"."Name". Then you will need another column to pull the "Candidate Identification"."Employee Number" in the same situation.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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