Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Timediff from one status to another — 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

Timediff from one status to another

Received Response
30
Views
2
Comments
edited Jul 2, 2019 10:39AM in Reporting and Analytics Taleo Enterprise 2 comments

Content

Hi,

I am trying to get the time taken from one status to another.

Ex: Need to know what is the time taken from to be reviewed to Initiate ability test

  From To
Step Name Under Review  Assessment
Status Name To Be Reviewed Initiate Ability Test

Tried below and couldn't succeed. Kindly help.

MIN(TIMESTAMPDIFF(SQL_TSI_DAY,(CASE "Submission CSW Status - Historical"."Historical Status Name" WHEN 'To Be Reviewed' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END),(CASE "Submission CSW Status - Historical"."Historical Status Name" WHEN 'Initiate Ability Test' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END)))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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