OBI field Most Advanced Requisition identifier retrieves no rows if there is single job submission — Cloud Customer Connect
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

OBI field Most Advanced Requisition identifier retrieves no rows if there is single job submission

edited Jun 27, 2025 7:41AM in Taleo Enterprise 1 comment

Summary:

We would like to retrieve the most latest job submission submitted by a candidate, For this purpose we are using the

available OBI field "Candidate Most Advanced Job Application"."Most Advanced Requisition Identifier"

However, "Most Advanced Requisition Identifier" field only retrieves data if and only if the candidates has done more than 1 submissions, for candidates where there is a single submission, this field retrieves no data.

To circumvent this, we have tried to write a case statement in the column formula as below:

CASE WHEN (IFNULL("Candidate Most Advanced Job Application"."Most Advanced Requisition Identifier", 1) = '1') THEN "Requisition Identification"."Req. Identifier" ELSE "Candidate Most Advanced Job Application"."Most Advanced Requisition Identifier" END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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