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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Need help with nested case statements

    edited Dec 13, 2022 7:04AM in Taleo Enterprise 12 comments

    Summary

    Need help with nested case statements

    Content

    I am trying to report the current status on a req. when the actual status is something else.  I also need to look at another field I set up to change the currect status.  I have the nested case statements below.  The first case statement works fine by itself but when I add the second one, I get an error.  Can anyone help?  Thanks.

    CASE WHEN "Requisition Status - Current"."Current Status" = 'Approved' OR "Requisition Status - Current"."Current Status" = 'Sourcing' THEN 'Approved and/or Sourcing' END ELSE
    MAX(CASE WHEN "Submission Job Offer"."Status" = 'Accepted' OR "Submission Job Offer"."Status" = 'Approval in Progress' OR "Submission Job Offer"."Status" = 'Approved' OR "Submission Job Offer"."Status" = 'Draft' OR "Submission Job Offer"."Status" = 'Extended' OR "Submission Job Offer"."Status" = 'In Negotiation' THEN 'Active Offer' END)

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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