What's new in Customer Journeys?

Connect and learn more!
Most advanced candidate report — 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

Most advanced candidate report

Received Response
edited Dec 13, 2022 7:05AM in Taleo Enterprise 9 comments


We have designed a report to provide the details of the most advanced candidate. The report pulls the candidate's step and status and also the candidate's name, need date


Report currently pulls the most advanced candidate for all open requisitions. The report pulls the step and status of the candidate and the name of the candidate. However, we would like to pull the date the candidate entered that status but we are having some difficulties. For the candidate name we used this formula, but it doesn't work for the date:


MAX(CASE WHEN Rank(CAST(Replace(concat(CAST("Submission CSW Status - Historical"."Historical Step Sequence" AS CHAR(5)),CAST("Submission CSW Status - Historical"."Historical Status Sequence" AS CHAR(5))),' ','') AS Integer) BY "Requisition Identification"."Req. Identifier")=1 THEN "Candidate Identification"."Name" ELSE '' END BY "Requisition Identification"."Req. Identifier")

Howdy, Stranger!

Log In

To view full details, sign in.


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